Import data from CSV
This topic describes how to import data into a Neon database table from a CSV file.
The instructions require a working installation of psql. The
psql client is the native command-line client for PostgreSQL. It provides an interactive session for sending commands to PostgreSQL. For more information about
psql, refer to the psql reference, in the PostgreSQL Documentation.
The following example uses the default
neondb database, a table named
customer, and a data file named
customer.csv. Data is loaded from the
customer.csv file into the
Connect to the
psql. For example:
For more information about connecting to Neon with
psql, see Connect with psql.
CREATE TABLE customer ( id SERIAL, first_name VARCHAR(50), last_name VARCHAR(50), email VARCHAR(255), PRIMARY KEY (id) )
You can also create tables using the SQL Editor in the Neon Console. See Query with Neon's SQL Editor.
customer.csvfile with the following data:
First Name,Last Name,Email 1,Casey,Smith,firstname.lastname@example.org 2,Sally,Jones,email@example.com
psqlprompt, load the data from the
customer.csvfile using the
\copy customer FROM '/path/to/customer.csv' DELIMITER ',' CSV HEADER
If the command runs successfully, it returns the number of records copied to the database:
For more information about the
\copyoption, refer to the psql reference, in the PostgreSQL Documentation.
Send a request to firstname.lastname@example.org, or join the Neon community forum.