Re: Importing from CSV, auto creating table?

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Importing from CSV, auto creating table?
Дата
Msg-id 3121bdd6-abd8-6bfe-21f8-2a904a7efe96@gmail.com
обсуждение исходный текст
Ответ на Importing from CSV, auto creating table?  (stan <stanb@panix.com>)
Ответы Re: Importing from CSV, auto creating table?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
On 8/21/19 4:15 PM, 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?

Data types.  Sure, you've got column names from the header line, but what 
types do you assign them?

>
> 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.
>
>

-- 
Angular momentum makes the world go 'round.



В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Complex filters -> Bad row estimates -> bad query plan
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Importing from CSV, auto creating table?