Postgres Pro
Downloads
Home   >   mailing lists

SQL to retrieve foreign keys - Mailing list pgsql-sql

From Colleen Williams
Subject SQL to retrieve foreign keys
Date
Msg-id 4.3.2.7.2.20001011165232.00b2a2d8@192.168.1.253
Whole thread Raw
Responses Re: SQL to retrieve foreign keys
List pgsql-sql
Tree view 
Hi,

I would like to write some SQL to extend the phpPgAdmin tool where it only 
displays primary keys related to a table. I have looked at the programmers 
doco and searched the discussions on foreign keys but was not able to 
decipher how to write the SQL. It is probably really trivial for someone 
who knows how the PostgreSQL catalog tables are related. Can someone please 
help me. Many Thanks.

Colleen.

pgsql-sql by date:

Previous
From: Mark Volpe
Date:
Subject: AFTER triggers, short question
Next
From: Stephan Szabo
Date:
Subject: Re: SQL to retrieve foreign keys