Top "Postgresql-copy" questions

COPY is an SQL command in PostgreSQL to move data between files and tables.

Importing CSV with commas in string values

I am trying to import a trivial CSV to Postgres 8.4 database: Here is a table: CREATE TABLE public.sample ( a …

Read More
postgresql csv postgresql-8.4 postgresql-copy
Using Postgres's COPY FROM file query in Python without writing to a temporary file

I need to load data from some source data sources to a Postgres database. To do this task, I first …

Read More
python postgresql csv postgresql-copy
COPY command: copy only specific columns from csv

I had a question surrounding the COPY command in PostgreSQL. I have a CSV file that I only want to …

Read More
postgresql header postgresql-copy
ERROR: could not stat file "XX.csv": Unknown error

I run this command: COPY XXX FROM 'D:/XXX.csv' WITH (FORMAT CSV, HEADER TRUE, NULL 'NULL') In Windows 7, it …

Read More
postgresql large-files postgresql-copy
Importing zipped CSV file into PostgreSQL

I have a big compressed csv file (25gb) and I want to import it into PostgreSQL 9.5 version. Is there any …

Read More
postgresql csv import named-pipes postgresql-copy