Import PostgreSQL data

The next step is to import the PostgreSQL data into YugabyteDB.

Note

After the data import step, remember to recreate any constraints and triggers that might have been disabled to speed up loading the data. This would ensure that the database will perform relational integrity checking for data going forward.

Import a database

To import an entire database from a pg_dump or ysql_dump export, use ysqlsh. The command should look as shown below.

$ ysqlsh -f <db-sql-script>

Tip

The ysqlsh tool is a derivative of the PostgreSQL tool, psql. All psql commands would work in ysqlsh.

Import a table using COPY FROM

Importing a single table (or a partial export from a table) can be done by running the COPY FROM command, and providing it the location of the export file prepared in a previous step. This should look as shown below.

COPY country FROM 'export.csv' DELIMITER ',' CSV HEADER;