[SQL] Extracting user db tabel info from system tables???

2001-01-05 Thread Marc Cromme
QUESTIONS ON USEFULL JOINS ON SYSTEM TABLES FOR USE WITH PHP-WEBINTERFACE I have some problems on making the right joins on system tables to extract the structure of some user defined tables/databases. I use PostgreSQL 7.0.2 on an RedHat 7.0 box. PROBLEM 1: I tried to make a Foreign key

Re: [SQL] Extracting user db tabel info from system tables???

2001-01-05 Thread Stephan Szabo
On Fri, 5 Jan 2001, Marc Cromme wrote: I have some problems on making the right joins on system tables to extract the structure of some user defined tables/databases. I use PostgreSQL 7.0.2 on an RedHat 7.0 box. PROBLEM 1: I tried to make a Foreign key constraint from the primary key