Join us on March 29th for Developer Days!Learn More
Import data

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 customer table.

  1. Connect to the neondb database using psql. For example:

    psql postgres://casey:<password>


    For more information about connecting to Neon with psql, see Connect with psql.

  2. Create the customer table.

    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.

  3. Prepare a customer.csv file with the following data:

    First Name,Last Name,Email
  4. From your psql prompt, load the data from the customer.csv file using the \copy option.

    \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:

    COPY 2

    For more information about the \copy option, refer to the psql reference, in the PostgreSQL Documentation.

Need help?

Send a request to, or join the Neon community forum.

Edit this page
Was this page helpful?