postgres_vectorization_test/input/load.source at master · citusdata/postgres_vectorization_test · GitHub

23 lines (17 loc) · 759 Bytes

-- Test loading data into cstore_fdw tables.

-- COPY with incorrect delimiter

COPY contestant FROM '@abs_srcdir@/data/contestants.1.csv'

WITH DELIMITER '|'; -- ERROR

-- COPY with invalid program

COPY contestant FROM PROGRAM 'invalid_program' WITH CSV; -- ERROR

-- COPY into uncompressed table from file

COPY contestant FROM '@abs_srcdir@/data/contestants.1.csv' WITH CSV;

-- COPY into uncompressed table from program

COPY contestant FROM PROGRAM 'cat @abs_srcdir@/data/contestants.2.csv' WITH CSV;

-- COPY into compressed table

COPY contestant_compressed FROM '@abs_srcdir@/data/contestants.1.csv' WITH CSV;

-- COPY into uncompressed table from program

COPY contestant_compressed FROM PROGRAM 'cat @abs_srcdir@/data/contestants.2.csv'

WITH CSV;

Expand file tree