Обсуждение: Deleting foreign key constraints
Hello, Is there a way to delete all foreign key constraints for a table? Also, is there a way to programmatically find all tables (excluding system created) in a database? I am using 7.1.3 Thanks much.
On Thu, 29 Aug 2002 05:44:14 -0400 pgsql-general-owner@postgresql.org wrote: > > Is there a way to delete all foreign key constraints for a table? > "ALTER <table> DROP <constraint>" should do it. See the SQL command reference for details. > Also, is there a way to programmatically find all tables (excluding > system created) in a database? > Call psql qith the "-E" option and enter "\d". Then psql will echo the internal SQL-commands used for collecting the info. Christoph Dalitz
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