Recently, I shared an article about copy your full database from one server to another server.
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:
\9.5\bin>pg_dump -U User_name -d database_name -t public.my_table > f:\my_table.sql
Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.
If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.
I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.