Saving table data locally and populating a table from a local machine

Using the interactive psql terminal, you can both copy table data to a local file and import data from a file to populate a table.

Getting startedGetting started

1. Get an SSL certificate.

2. Install the dependencies:

   sudo apt update && sudo apt install --yes postgresql-client
   

Copying data from a tableCopying data from a table

To export table data to a file, run this command:

psql "host=c-<cluster_ID>.rw.mdb.yandexcloud.net \
    port=6432 \
    sslmode=verify-full \
    dbname=<DB_name> \
    user=<username> \
    target_session_attrs=read-write" \
    -c "\copy (SELECT * FROM <table_name>) to stdout (DELIMITER '<delimiter_character>')" \
    >> <local_file_name>

Populating a table with dataPopulating a table with data

To import data from a local file into a table, run this command:

cat <local_file_name> | \
psql "host=c-<cluster_ID>.rw.mdb.yandexcloud.net \
    port=6432 \
    sslmode=verify-full \
    dbname=<DB_name> \
    user=<username> \
    target_session_attrs=read-write" \
    -c "COPY <table_name> FROM stdin (DELIMITER '<delimiter_character>')"