DEV Community

EliasAnJr
EliasAnJr

Posted on

How to do Postgres dump specific table with a capital letter in 2025

This command worked on Linux Ubuntu:

pg_dump -h server.postgres.database.azure.com -p 5432 -U user-name -t '"schema-name"."Table-name"' --no-owner --no-privileges --format c -vvv -d database-name > table.dump

Note that the schema and table name are being passed here -t ‘“schema-name”.”Table-name”’

Also note that after the -t flag contains a single quote ‘ and a double “

I hope that this information help a lot of people comunity tech. 😊

Top comments (0)