Re: Schema objects - Mailing list pgsql-admin

From Milen A. Radev
Subject Re: Schema objects
Date
Msg-id fegq1r$624$1@sea.gmane.org
Whole thread Raw
In response to Schema objects  ("Lucas Martino" <lucas.martino@gmail.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Lucas Martino"
Date:
Subject: Schema objects
Next
From: "David Rovner"
Date:
Subject: persistent 'psql: FATAL: "listen_addresses" cannot be changed after server start