Re: Ragged CSV import

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Ragged CSV import
Дата
Msg-id 4AA86722.1070203@dunslane.net
обсуждение исходный текст
Ответ на Re: Ragged CSV import  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Ragged CSV import  (Robert Haas <robertmhaas@gmail.com>)
Re: Ragged CSV import  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Robert Haas wrote:
> I wonder whether it would be appropriate to do something like
> implement a method by which copy could return text[] and then one
> could write wrappers around that functionality to do this as well as
> other things.  
>   

It's not a function ... writing a copy() function returning text[] (or 
setof text[], which would be better) in plperlu would be trivial. But it 
couldn't read from stdin or be able to be fed data from a client in 
copy-in mode.

And even if we have it what does the sql look like to insert the values 
into some table with n columns?

Anything along these lines in C is likely to be far larger than what I 
had in mind, which was a fairly minor enhancement.

cheers

andrew


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: CommitFest 2009-09 Plans and Call for Reviewers
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Ragged CSV import