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 tab…


This content originally appeared on DEV Community and was authored by EliasAnJr

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. 😊


This content originally appeared on DEV Community and was authored by EliasAnJr


Print Share Comment Cite Upload Translate Updates
APA

EliasAnJr | Sciencx (2025-01-31T19:12:06+00:00) How to do Postgres dump specific table with a capital letter in 2025. Retrieved from https://www.scien.cx/2025/01/31/how-to-do-postgres-dump-specific-table-with-a-capital-letter-in-2025/

MLA
" » How to do Postgres dump specific table with a capital letter in 2025." EliasAnJr | Sciencx - Friday January 31, 2025, https://www.scien.cx/2025/01/31/how-to-do-postgres-dump-specific-table-with-a-capital-letter-in-2025/
HARVARD
EliasAnJr | Sciencx Friday January 31, 2025 » How to do Postgres dump specific table with a capital letter in 2025., viewed ,<https://www.scien.cx/2025/01/31/how-to-do-postgres-dump-specific-table-with-a-capital-letter-in-2025/>
VANCOUVER
EliasAnJr | Sciencx - » How to do Postgres dump specific table with a capital letter in 2025. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/01/31/how-to-do-postgres-dump-specific-table-with-a-capital-letter-in-2025/
CHICAGO
" » How to do Postgres dump specific table with a capital letter in 2025." EliasAnJr | Sciencx - Accessed . https://www.scien.cx/2025/01/31/how-to-do-postgres-dump-specific-table-with-a-capital-letter-in-2025/
IEEE
" » How to do Postgres dump specific table with a capital letter in 2025." EliasAnJr | Sciencx [Online]. Available: https://www.scien.cx/2025/01/31/how-to-do-postgres-dump-specific-table-with-a-capital-letter-in-2025/. [Accessed: ]
rf:citation
» How to do Postgres dump specific table with a capital letter in 2025 | EliasAnJr | Sciencx | https://www.scien.cx/2025/01/31/how-to-do-postgres-dump-specific-table-with-a-capital-letter-in-2025/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts