Home > mailing lists

Re: Import csv to temp table - Mailing list pgsql-general

From	Ron Johnson
Subject	Re: Import csv to temp table
Date	January 2 16:49:36
Msg-id	CANzqJaDck5zK3E6DXzvjVJvoKvHnY9b__QwPy4oLoCVGer31ow@mail.gmail.com Whole thread Raw
In response to	Import csv to temp table (arun chirappurath <arunsnmimt@gmail.com>)
List	pgsql-general

On Tue, Jan 2, 2024 at 7:02 AM arun chirappurath <arunsnmimt@gmail.com> wrote:

Dear All,

Do we have any scripts that create a temp table with column names from the first row of csv files?

How would you determine the data type?

If you assume TEXT for all of them, then it's relatively simple to write bash which does it.

From: Arbol One
Date: 02 January, 16:12:32
Subject: Testing - Please ignore/delete this message

From: Hilary Cotter
Date: 02 January, 17:13:18
Subject: Re: Testing - Please ignore/delete this message