postgresql-copy

Export specific rows from a PostgreSQL table as INSERT SQL script

by

I have a database schema named: nyummy and a table named cimory: create table nyummy.cimory ( id numeric(10,0) not null, name character varying(60) not null, city character varying(50) not null, CONSTRAINT cimory_pkey PRIMARY KEY (id) ); I want to export the cimory table’s data as insert SQL script file. However, I only want to export … Read more

How to export table as CSV with headings on Postgresql?

by

I’m trying to export a PostgreSQL table with headings to a CSV file via command line, however I get it to export to CSV file, but without headings. My code looks as follows: COPY products_273 to ‘/tmp/products_199.csv’ delimiters’,’; 14 Answers 14 COPY products_273 TO ‘/tmp/products_199.csv’ WITH (FORMAT CSV, HEADER); as described in the manual.

How to import CSV file data into a PostgreSQL table

by

How can I write a stored procedure that imports data from a CSV file and populates the table? 23 s 23 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); … Read more