Postgres Pro
Downloads
Home   >   mailing lists

Re: Backup schema without data - Mailing list pgsql-general

From Brent Wood
Subject Re: Backup schema without data
Date
Msg-id 694694106.675857.1680829152749@mail.yahoo.com
Whole thread Raw
In response to Backup schema without data  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
Tree view
Looking at the result of:

pg_dump --help

Usage:
  pg_dump [OPTION]... [DBNAME]
...
 -n, --schema=PATTERN         dump the specified schema(s) only
...
 -s, --schema-only            dump only the schema, no data
... 


So: pg_dump -s -n <schema> <db>

It works for me...


Cheers

Brent Wood


On Friday, April 7, 2023 at 12:40:58 PM GMT+12, Atul Kumar <akumar14871@gmail.com> wrote:


Hi,

Please help me in telling that how I can take the backup of one single schema without its data using pg_dump utility ?


So far, I could not find anything suitable for doing so.

Regards,
Atul

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backup schema without data
Next
From: Louis Tian
Date:
Subject: Re: [EXTERNAL]: Re: UPSERT in Postgres