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)

Postgres on Neon - Get the Free Plan

No credit card required. The database you love, on a serverless platform designed to help you build faster.

Get Postgres on Neon