On Thu, 29 Aug 2002 05:44:14 -0400
pgsql-general-owner(at)postgresql(dot)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