Import data from CSV into Postgres¶

Table of contents

Introduction
Step 1: Add a corresponding table to your PG database
Step 2: Connect to your Postgres database
Step 3: Import the data from the CSV file

Introduction¶

You might have existing data stored in a CSV file that you need to import into your Postgres database. The following guide will show how to do so.

Let’s assume we have the following CSV file, which is named profile.csv:

Step 1: Add a corresponding table to your PG database¶

Let us create a table to match the data structure in your CSV file.

profile (
  firstName TEXT,
  lastName TEXT,
  email VARCHAR
)

Step 2: Connect to your Postgres database¶

Connect to your Postgres database by using the psql command on the terminal:

psql postgres://<username>:<password>@<host>:<port>/<database>

# for example
psql postgres://postgres:postgres@localhost:5432/postgres

Step 3: Import the data from the CSV file¶

Once connected to the database, use the following command from inside psql to import the data:

\copy <table_name> from '</path/to/file/filename.csv>' delimiter ',' CSV HEADER;

# for example
\copy profile from '/Users/sarahlewis/documents/profile.csv' delimiter ',' CSV HEADER;

Your data would have been successfully copied into the Postgres database.

« previous | next »

Want to contribute or report missing content?

edit this page on github | contributing guidelines | report an issue

Hasura GraphQL engine is open source. See license