On Wed, Jan 17, 2024 at 1:46 PM Atul Kumar wrote:
> Hi,
>
> I am not able to find any solution to list all schemas in all databases at
> once, to check the structure of the whole cluster.
>
> As I need to give a few privileges to a user to all databases, their
> schemas and schemas' objects
On 1/17/24 12:46 PM, Atul Kumar wrote:
Hi,
I am not able to find any solution to list all schemas in all databases
at once, to check the structure of the whole cluster.
Easiest way to do this is `pg_dumpall --schema-only`.
--
Jim Nasby, Data Architect, Austin TX
On 2024-01-17 19:46 +0100, Atul Kumar wrote:
> I am not able to find any solution to list all schemas in all databases at
> once, to check the structure of the whole cluster.
You have to connect to each database and run the necessary statements
per database.
> As I need to give a few privileges
Hi,
I am not able to find any solution to list all schemas in all databases at
once, to check the structure of the whole cluster.
As I need to give a few privileges to a user to all databases, their
schemas and schemas' objects (tables sequences etc.).
Please let me know if there is any
