Re: Re: new set of psql patches for loading (saving) datafrom (to) text, binary files - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Re: new set of psql patches for loading (saving) datafrom (to) text, binary files
Date
Msg-id 20170405230131.7hrtqdwpcvsgi3aa@alap3.anarazel.de
Whole thread Raw
In response to [HACKERS] Re: new set of psql patches for loading (saving) data from (to) text,binary files  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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 by date:

Previous
From: Pierre Ducroquet
Date:
Subject: Bug with pg_basebackup and 'shared' tablespace
Next
From: Michael Paquier
Date:
Subject: Re: scram and \password