Re: Importing from CSV, auto creating table? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Importing from CSV, auto creating table?
Date
Msg-id CAKFQuwYj5kcEfD_4d6uL0benif_WQ8fDzY_+ogqk_G6U5yq=Ww@mail.gmail.com
Whole thread Raw
In response to Importing from CSV, auto creating table?  (stan <stanb@panix.com>)
List pgsql-general
On Wed, Aug 21, 2019 at 2:15 PM stan <stanb@panix.com> wrote:
I have a situation where we need to import data, as an interim measure,
from spreadsheets.

I have read up on \copy and COPY, but I do not see that either of these can
use the header from a CSV file to define a new table. Am I missing
something?


Nope.  You need to create the table separately - or find a tool that will do that creation for you.

David J.

pgsql-general by date:

Previous
From: Mathieu Fenniak
Date:
Subject: Re: Complex filters -> Bad row estimates -> bad query plan
Next
From: DiasCosta
Date:
Subject: Re: Importing from CSV, auto creating table?