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

From DiasCosta
Subject Re: Importing from CSV, auto creating table?
Date
Msg-id a987fd4c-27f3-7f2a-44d3-08ad911f8e0a@diascosta.org
Whole thread Raw
In response to Importing from CSV, auto creating table?  (stan <stanb@panix.com>)
List pgsql-general
Hi Stan,

I uploaded to the database (PostgreSQL 9.6), monthly and for several years, over 50 000 000 csv records
using a version of pgtfutter that I compiled (with some changes if I remember correctly) and the tables
were created in
loading process from the column titles.

Dias Costa




On 21-08-2019 22:15, stan 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?

Also downloaded something called pgfutter, which I thought would do this,
but have not had any success with this. After I (thought) I had figured out
the arguments, it just seams to hag forever.




-- 
J. M. Dias Costa
Telef. 214026948    

Se divulgar esta mensagem por terceiros, por favor:
1. Apague o meu endereço de correio electrónico e o meu nome.
2. Apague também os endereços dos seus amigos antes de distribuir.
3. Enderece como cópia oculta (Cc ou Bcc) para os SEUS destinatários.
Agindo deste modo, dificultará a disseminação de "vírus", "spams" e
"banners" e contribuirá para manter a privacidade de todos e cada um.
Obrigado.

Nota: Não se deverá ao acaso a ocorrência de palavras na minha escrita que não respeitem o 
malfadado acordo ortográfico.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Importing from CSV, auto creating table?
Next
From: Michael Lewis
Date:
Subject: Re: Complex filters -> Bad row estimates -> bad query plan