How can I use postgres' COPY FROM correctly?

Question

I have a csv file with headers. 4 columns.

I need the first 3 columns in table A, and the last column in table B.

Table A has an ID, which should be set by default (not from columns).

Here's what I've tried:

COPY a FROM '/home/bijan/Downloads/test_events.csv' WITH CSV HEADERS

The (first) problem I run into with this is it's not setting the default value for the ID of the table 'A', instead it thinks the first column of the CSV is the first column in the table (which should be default).

Thank you for your time. :)

Magnus Hagander · Accepted Answer · 2010-12-26 09:38:31Z

5

You're probably best off loading it into a temporary table and then sending that one to the two different other tables - you cannot load into two tables in one operation.

You can, however, control which columns the data goes into (thus skipping the id column), with something like

COPY a(col2,col3,col4) FROM '/home/bijan/Downloads/test_events.csv' WITH CSV HEADERS

answered Dec 26, 2010 at 9:38

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I use postgres' COPY FROM correctly?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related