Re: Foreign Key?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Sam Cao <scao(at)verio(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Foreign Key?
Date: 2002-01-21 21:13:59
Message-ID: 20020121131110.O96261-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


On Mon, 21 Jan 2002, Sam Cao wrote:

> First time user of Postgresql....
> After created the database, how do I check what foreign keys (constraint
> references in Postgresql term) were created? I looked around using
> "psql" and "pgaccess", but no success,

Best thing to look at probably is the "Referential Integrity Tutorial &
Hacking the Referential Integrity Tables" tutorial at
http://techdocs.postgresql.org/

I believe that includes a view definition that gets alot of that
information out.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Munro 2002-01-21 21:38:27 Re: row based security ... was Different views with same
Previous Message Peter Eisentraut 2002-01-21 21:12:58 Re: [HACKERS] PostgreSQL Licence: GNU/GPL

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-01-21 21:29:52 RFD: schemas and different kinds of Postgres objects
Previous Message Peter Eisentraut 2002-01-21 21:12:58 Re: [HACKERS] PostgreSQL Licence: GNU/GPL