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 …

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 …

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 …

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 …

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 …

postgresql csv import named-pipes postgresql-copy
Execute COPY command in remote database using local file

I'm trying to execute the Postgres COPY command. COPY warehouse_terminal.test_table FROM 'C:\file.csv' DELIMITERS E'\t' …

sql postgresql remote-access bulk-load postgresql-copy
COPY with dynamic file name

I am trying to write a function to load csv data into a table. I want the input argument to …

sql postgresql plpgsql dynamic-sql postgresql-copy