Re: Re: new set of psql patches for loading (saving) datafrom (to) text, binary files

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Re: new set of psql patches for loading (saving) datafrom (to) text, binary files
Дата
Msg-id 20170405230131.7hrtqdwpcvsgi3aa@alap3.anarazel.de
обсуждение исходный текст
Ответ на [HACKERS] Re: new set of psql patches for loading (saving) data from (to) text,binary files  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Hi,

On 2017-03-18 17:51:48 +0100, Pavel Stehule wrote:
> What is done:
> 
> create table foo foo(a bytea);
> 
> -- import
> insert into foo values($1)
> \gloadfrom ~/xxx.jpg bytea
> 
> -- export
> \pset format binary
> select a from foo
> \g ~/xxx2.jpg
> 
> tested on import 55MB binary file
> 
> Comments, notes?
> 
> Available import formats are limited to text, bytea, xml - these formats
> are safe for receiving data via recv function.

I don't think we have design agreement on this at this point.  Given the
upcoming code freeze, I think we'll have to hash this out during the
next development cycle.  Any counterarguments?

- Andres



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

Предыдущее
От: Pierre Ducroquet
Дата:
Сообщение: Bug with pg_basebackup and 'shared' tablespace
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: scram and \password