list all foreign keys for a table postgres

Solutions on MaxInterview for list all foreign keys for a table postgres by the best coders in the world

showing results for - "list all foreign keys for a table postgres"

1select kcu.table_schema || '.' ||kcu.table_name as foreign_table,
2       '>-' as rel,
3       rel_tco.table_schema || '.' || rel_tco.table_name as primary_table,
4       string_agg(kcu.column_name, ', ') as fk_columns,
5       kcu.constraint_name
6from information_schema.table_constraints tco
7join information_schema.key_column_usage kcu
8          on tco.constraint_schema = kcu.constraint_schema
9          and tco.constraint_name = kcu.constraint_name
10join information_schema.referential_constraints rco
11          on tco.constraint_schema = rco.constraint_schema
12          and tco.constraint_name = rco.constraint_name
13join information_schema.table_constraints rel_tco
14          on rco.unique_constraint_schema = rel_tco.constraint_schema
15          and rco.unique_constraint_name = rel_tco.constraint_name
16where tco.constraint_type = 'FOREIGN KEY'
17group by kcu.table_schema,
18         kcu.table_name,
19         rel_tco.table_name,
20         rel_tco.table_schema,
21         kcu.constraint_name
22order by kcu.table_schema,
23         kcu.table_name;

similar questions

postgres check for foreign key postgresql get table names postgresql how to show table names psql list tables in schema psql create table foreign keys list column names of multiple tables psql postgres add foreign key to existing table how to check table in postgresql from terminal postgresql list columns show table postgres command create table postgresql foreign key show table details postgresql how to list columns for particular tables in postgresql postgres list tables and row counts get all tables postgres show all tables postgres postgres remove foreign key constraint show details of table postgres

queries leading to this page

get foreign keys for a table postgres postgresql how to find all tables that refer to one as foreign key psql create table with list of foreign key psql list table foreign keys find all foreign keys postgres select foreign key postgres postgres get foreign key constraint name postgres list foreign keys psql list foreign keys foreign keys list psql foreign key postgresql list get all foreign keys postgresql list all foreign keys for a table postgres constraint to get all related foreingkey in postgree postgres get foreign key constrain show foreign key postgresql in table postgresql foreign key get all table how to check foreign keys in table postgresql list foreign key constraint postgres show foreign key postgres show foreign keys on table postgres find foreign key postgres postgres foreign key list of postgres list foreign keys on table postgress list foreign key postgres find foreign key references postgresql show table foreign keys pg list foreign keys postgres field create list of foreign keys postgresql foreign key list columnb view foreign keys posgress postgresql list of foreign keys postgresql find foreign key references how can i list all foreign keys referencing a given table in postgres show foreign key postgresql postgresql colum that is a list of foreign keys psql how to get info from foeign key in foreign key how to get foreign key column name in postgres of a table get all foreign key constrains for postgres postgres get foreign key name from columns postgresql foreign key list column postgresql get all foreign key references with table name how to find your table foreign key in postgres postgres field list of foreign keys postgres get all foreign keys on table list fk from table postgres postgresql get all foreign keys constraints postgres to obtain all foreign key show all foreign key constatins of a postgres database postgresql get foreign key columns postgresql get all foreign key references postgresql list table foreign keys postgres get all foreign key references to column get foreign key of table postgres view foreign keys of table postgresql find table by fk postgres find table from foreign key postgres postgresql foreign key list get foreign keys of table postgres foreign key postgresql list field how to check the foregin key postgres postgresql get all foreign keys that reference a given table how to get the foreign keys of a table in sql postgres postgresql list all foreign key constraints list all foreign keys for a table postgres