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