PostgreSQL: How to take a backup of your Table?

Recently, I shared an article about copy your full database from one server to another server.

PostgreSQL: Copy Database to another Server in Windows (pg_dump – backup & restore)

I found one question on PostgreSQL FB Group like “How to take a backup of a table in PostgreSQL.”

You can do this exercise using pg_dump utility and pgAdmin tool.

Using pgAdmin tool:
Right-click on a table and select backup option. In Dump Option window, you can find an option like backup Only schema, backup Only Data. Enter your file name path, select backup mode as plain text and take the backup of your table. You can restore this table in any database.

Using psql, pg_dump utility:

Anvesh Patel

Leave a Reply

Be the First to Comment!

Notify of