weedpax.blogg.se

The file must be accessible by the PostgreSQL user (the user ID the server runs as) and the name must be specified from the viewpoint of the server.

Table columns not specified in the COPY FROM column list will receive their default values.ĬOPY with a file name instructs the PostgreSQL server to directly read from or write to a file. For COPY FROM, each field in the file is inserted, in order, into the specified column. If a column list is specified, COPY TO copies only the data in the specified columns to the file. COPY TO can also copy the results of a SELECT query. COPY TO copies the contents of a table to a file, while COPY FROM copies data from a file to a table (appending the data to whatever is in the table already).

COPY moves data between PostgreSQL tables and standard file-system files.