Version 7.0 (Released May 2000)
Implemented FOREIGN KEYS (except PARTIAL MATCH FKs).
Major overhaul to query optimizer.
Psql client application added many new features.
Date-time data types now SQL-92–compliant.
Removed fixed-length limit of query strings.
Maximum number of keys in an index increased to 16 from 8.
Sorts and hashes fixed to work on greater than 2GB of data.
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.
