How to import CSV file data into a PostgreSQL table

by

Take a look at this short article.

The solution is paraphrased here:

Create your table:

CREATE TABLE zip_codes
(ZIP char(5), LATITUDE double precision, LONGITUDE double precision,
CITY varchar, STATE char(2), COUNTY varchar, ZIP_CLASS varchar);

Copy data from your CSV file to the table:

COPY zip_codes FROM '/path/to/csv/ZIP_CODES.txt' WITH (FORMAT csv);

More Related Contents:

  1. How to export table as CSV with headings on Postgresql?
  2. Save PL/pgSQL output from PostgreSQL to a CSV file
  3. Can I automatically create a table in PostgreSQL from a csv file with headers?
  4. In PostgreSQL, how to insert data with COPY command?
  5. ERROR: could not stat file “XX.csv”: Unknown error
  6. Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy
  7. PostgreSQL: export resulting data from SQL query to Excel/CSV
  8. Generating time series between two dates in PostgreSQL
  9. How to do an update + join in PostgreSQL?
  10. How to perform update operations on columns of type JSONB in Postgres 9.4
  11. Store common query as column?
  12. How does PostgreSQL enforce the UNIQUE constraint / what type of index does it use?
  13. How to convert primary key from integer to serial?
  14. How to drop a PostgreSQL database if there are active connections to it?
  15. postgresql duplicate key violates unique constraint
  16. gem install pg –with-pg-config works, bundle fails
  17. Find difference between timestamps in seconds in PostgreSQL
  18. Unable to connect PostgreSQL to remote database using pgAdmin
  19. How can I change a PostgreSQL user password?
  20. Docker wait for postgresql to be running
  21. I forgot the password I entered during PostgreSQL installation
  22. Postgresql enforce unique two-way combination of columns
  23. Composite PRIMARY KEY enforces NOT NULL constraints on involved columns
  24. how to store PostgreSQL jsonb using SpringBoot + JPA?
  25. Orbeon Forms Postgres DB connection
  26. Postgres default sort by id – worldship
  27. Best way to install hstore on multiple schemas in a Postgres database?
  28. Loop through columns of RECORD
  29. How to drop PostgreSQL database through command line [closed]
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment