Re: Deleting foreign key constraints

On Thu, 29 Aug 2002, Nikhil G. Daddikar wrote:

> Is there a way to delete all foreign key constraints for a table?

Not a particularly good one.  You'll probably need to drop the triggers
manually (from both that table and the table it references) and you'll
need to match up the arguments to do that.  There's some info on
techdocs.postgresql.org about the triggers that you might find useful.

> Also, is there a way to programmatically find all tables (excluding
> system created) in a database?

Check the query generated by psql for a \d (use psql -E to get the
the query).  It'll be something with pg_class.

>
> I am using 7.1.3