Materialize Logo

COPY FROM

COPY FROM copies data into a table using the Postgres COPY protocol.

Syntax

COPY table_name ( column , ) FROM STDIN WITH ( option , )
Field Use
table_name The name of the table to be copied.
column An optional list of columns to be copied. If no column list is specified, all columns of the table will be copied.

Supported option values:

Name Default value Description
DELIMITER tab character Specifies the character that separates columns within each row (line) of the file.
NULL \N (backslash-N) Specifies the string that represents a null value.

Rows are expected in text format, one per line, with columns separated by the DELIMITER character.

Example

COPY t FROM STDIN
Did this info help?
Yes No