Re: Importing from CSV, auto creating table?
От | DiasCosta |
---|---|
Тема | Re: Importing from CSV, auto creating table? |
Дата | |
Msg-id | a987fd4c-27f3-7f2a-44d3-08ad911f8e0a@diascosta.org обсуждение исходный текст |
Ответ на | Importing from CSV, auto creating table? (stan <stanb@panix.com>) |
Список | 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 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 по дате отправления: