Version 6.1 (Released June 1997)
BTREE UNIQUE added to bulk load code.
Massive changes to libpg++ (Leo).
New GEQO optimizer speeds table multitable optimization.
New WARN message for nonunique insert into unique key.
New plaintext password functions.
New ANSI timestamp function.
New ANSI time and date types.
Multicolumn B-Tree indexes.
New SET var TO value command.
New locale settings for character types.
New SEQUENCE serial number generator.
GROUP BY function now possible.
New MONEY data type.
New VACUUM option for attribute statistics and for certain columns.
New SET, SHOW, and RESET commands.
New \connect database USER option.
New destroydb -i option.
New \dt and \di psql commands.
SELECT \n now escapes newline.
Get PostgreSQL Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
