How to delete/drop a constraint in PostgresSQL
This article will show you how to drop a constraint, such as a foreign key constraint, on a PostgresSQL 8.x database.
- Login to the PostgresSQL command-line interface
- Show a list of constraints on a particular table
- To Delete (or Drop) the constraint, use the command:
psql -U [username] [database_name]
\d [table_name]
ALTER TABLE [table_name] DROP CONSTRAINT [constraint_name];