Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Loftis
Subject Re: Backup schema without data
Date
Msg-id CAHDg04s0zDtg1vrSR7ts5DyfFw+MkVPBoDo8ZsWqyoUn59foog@mail.gmail.com
Whole thread Raw
In response to Backup schema without data  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
Tree view
From the man page….

“

-s
--schema-only

Dump only the object definitions (schema), not data.

…..”


On Thu, Apr 6, 2023 at 18:40 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

--

"Genius might be described as a supreme capacity for getting its possessors
into trouble of all kinds."
-- Samuel Butler

pgsql-general by date:

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