Showing posts with label pg_dump and pg_restore. Show all posts
Showing posts with label pg_dump and pg_restore. Show all posts
Friday, August 26, 2022

How to generate insert statements for a table in PostgreSQL

›
Thanks to Carlos Becker for pointing out the following solution on how to generate insert statments for a table in PostgreSQL pg_dump myd...
Wednesday, April 6, 2022

Wrappers for pg_dump and pg_restore

›
Export: #pg_dump dumps a database as a text file or to other formats. #!/bin/bash export SCRIPT_NAME=`basename $0` export HOST=`uname -n` e...
Monday, October 18, 2021

How to export a single table in PostgreSQL

›
Example of exporting a single table. In the directory-format: pg_dump -Fd mydb -t myschema.mytable -v -f /data/mydirectory -j 2 Where...
Thursday, September 16, 2021

How to list the contents of a custom format PostgreSQL export file

›
List the content of a "custom format" export file created by pg_dump by specifying the -l flag : pg_restore /data1/exports/mu...
Tuesday, September 14, 2021

How to export and import a schema using the directory format

›
What exactly is the directory format used by pg_dump?    The documentation states:    Dumps can be output in script or archive file format...
Thursday, August 13, 2020

How to perform a full export and import of an entire database in PostgreSQL

›
Export the database "db01" from your source postgres server: pg_dump db01 -v -Fc >db01.dmp The -v means ...
Monday, February 17, 2020

How to export and import a schema in PostgreSQL

›
Schema exports and imports There are many ways to export a schema using pg_dump: Export the schema scott from db01, data only, no me...