Search Postgresql Archives

Re: unbale to list schema

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: unbale to list schema
From: Jim Nasby <jim.nasby@xxxxxxxxx>
Date: Wed, 17 Jan 2024 17:04:15 -0600
In-reply-to: <CA+ONtZ6cYh=9BkUROkMuyaV9d7kp4f3Vyn4yuavT9JZc=i77Pw@mail.gmail.com>
References: <CA+ONtZ6cYh=9BkUROkMuyaV9d7kp4f3Vyn4yuavT9JZc=i77Pw@mail.gmail.com>
User-agent: Mozilla Thunderbird

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 databasesat 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- unbale to list schema
  - From: Atul Kumar

Prev by Date: Disk Groups/Storage Management for a Large Database in PostgreSQL
Next by Date: Re: Mimic ALIAS in Postgresql?
Previous by thread: Re: unbale to list schema
Next by thread: Re: unbale to list schema
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux