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 
<akumar14...@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
  

Reply via email to