Postgres Pro
Downloads
Home   >   mailing lists

Re: unbale to list schema - Mailing list pgsql-general

From Jim Nasby
Subject Re: unbale to list schema
Date
Msg-id 9db9ed8f-681c-43aa-b6bc-b985a69fc1af@gmail.com
Whole thread Raw
In response to unbale to list schema  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Moving to Postgresql database
Next
From: Michael Nolan
Date:
Subject: Re: undefined symbol when installing pgcrypto on 16.1