Re: Schema objects

Lucas Martino написа:
> Hello,
> i need list all tables, functions, procedures, triggers, sequences of a
> specific schema. How can i do this?

One way (the only one I could think of) is to dump the schema using the
custom format and then use the pg_restore to list the contents of the
dump file:

pg_dump --format=c --schema=a_schema --schema-only --file=x.dump a_database

and then:

pg_restore --list x.dump

Probably someone would suggest a more direct way.

--
Milen A. Radev