Re: how to get dependancies of a table?

nobs@nobswolf.info (Emil Obermayr) writes:
> Instead I would prefer to see the dependancies. I have no idea where to
> look.

Fix whatever client you're using to not throw away NOTICE messages ...

regression=# create table foo (f1 int primary key);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey" for table "foo"
CREATE TABLE
regression=# create table bar (d1 int references foo);
CREATE TABLE
regression=# create table baz (d1 int references foo);
CREATE TABLE
regression=# drop table foo;
NOTICE:  constraint baz_d1_fkey on table baz depends on table foo
NOTICE:  constraint bar_d1_fkey on table bar depends on table foo
ERROR:  cannot drop table foo because other objects depend on it
HINT:  Use DROP ... CASCADE to drop the dependent objects too.

            regards, tom lane