PostgreSQL Import Export Table Example

Export table

Pg_dump-h localhost-u postgres (user name) database name (with user name by default)-T table (table name) > Dump.sql

Import Table

Psql-f Dump.sql

Example of a complete import export table

1, check the original database

-bash-3.2$ psql-u playboy-d Playboy//Original database
Welcome to Psql 8.1.23, the PostgreSQL Interactive terminal.
Type: \copyright for distribution Terms
\h for help with SQL commands
\? For help with Psql commands
\g or terminate with semicolon to execute query
\q to quit

Playboy=> \dt;
List of relations
Schema | Name |  Type | Owner
--------+------------+-------+---------
Public | Contents | Table | Playboy
Public | Entries | Table | Playboy
Public | Properties | Table | Playboy
Public | Settings | Table | Playboy
Public | Test | Table | Playboy
(5 rows)

Playboy=> \q

2, Export database and table

1.-bash-3.2$ pg_dump-o Playboy >/var/lib/pgsql/data/playboy2013.sql     // Export Playboy database   
2. 
3.-bash-3.2$ pg_dumpall >/var/lib/pgsql/data/all_databases2013.sql        //Export all databases   
4. 
5.-bash-3.2$ pg_dump-o playboy-ft -T Test >/var/lib/pgsql/data/playboy_test2013.tar  //Export a table. tar files for pg_restore  
6.  
7.-bash-3.2$ ls/var/lib/pgsql/data |grep 2013                              //View the guide   
8.playboy2013.sql all_databases2013.sql playboy_test2013.tar 
-bash-3.2$ Pg_dump-o Playboy >/var/lib/pgsql/data/playboy2013.sql     //Export Playboy database

-bash-3.2$ pg_dumpall >/var/lib/pgsql/data/all_databases2013.sql//Export all databases

-bash-3.2$ pg_dump-o playboy-ft-t Test >/var/lib/pgsql/data/playboy_test2013.tar//Export a table. tar files for Pg_restore

-bash-3.2$ ls/var/lib/pgsql/data |grep 2013//Check it out, guide.
Playboy2013.sql All_databases2013.sql Playboy_test2013.tar3, create a new database, and import

 
-bash-3.2$ psql-u playboy-d playboy          & nbsp;                         //Original database
Welcome to Psql 8.1.23, the PostgreSQL Interactive terminal.
type:  \copyright for distribution Terms
       \h to help with SQL commands
& nbsp;      \? For help with psql commands
       \g or terminate with semicolon to execute query
& nbsp;      \q to quit

Playboy=> \dt;
List of relations
Schema | Name |  Type | Owner
--------+------------+-------+---------
Public | Contents | Table | Playboy
Public | Entries | Table | Playboy
Public | Properties | Table | Playboy
Public | Settings | Table | Playboy
Public | Test | Table | Playboy
(5 rows)

Playboy=> \q

-bash-3.2$ createdb playboy_test-o Playboy//Create a database belonging to Playboy Playboy_test
CREATE DATABASE

-bash-3.2$ pg_restore-d Playboy_test/var/lib/pgsql/data/playboy_test2013.tar//Import single table,

After the import table is deleted, the Playboy database is imported into the Playboy_test, and the permissions belong to Playboy
-bash-3.2$ psql-d playboy_test-u playboy-f/var/lib/pgsql/data/playboy2013.sql
SET
SET
SET
COMMENT
SET
CREATE SEQUENCE
Setval
--------
18
(1 row)

SET
SET
CREATE TABLE
CREATE SEQUENCE
Setval
--------
4
(1 row)

CREATE TABLE
CREATE TABLE
CREATE SEQUENCE
Setval
--------
3
(1 row)

CREATE TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
REVOKE
REVOKE
GRANT
GRANT

-bash-3.2$ psql-u playboy-d playboy_test//Login to Playboy_test
Welcome to Psql 8.1.23, the PostgreSQL Interactive terminal.

type:  \copyright for distribution Terms
       \h to help with SQL commands       ? For help with psql commands
       \g or terminate with semicolon to execute query
& nbsp;      \q to quit

Playboy_test=> \dt; Look at the table, the same as the root Playboy database.
List of relations
Schema | Name |  Type | Owner
--------+------------+-------+----------
Public | Contents | Table | Playboy
Public | Entries | Table | Playboy
Public | Properties | Table | Playboy
Public | Settings | Table | Playboy
Public | Test | Table | Playboy

(5 rows)

Pgsql Import write more, above already has two kinds of, say a kind of

1.-bash-3.2$ psql-u Playboy Playboy_test </var/lib/pgsql/data/playboy2013.sql