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