select * from information_schema.key_column_usage returns
ERROR: more than one row returned by a subquery used as an expression SQL state: 21000 How to reconstruct primay and foreign key statements ? Andrus. "PostgreSQL 8.1.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" PgAdmin 1.6 beta 3 Windows XP Andrus. ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq