Re: [HACKERS] export import bytea from psql - Mailing list pgsql-hackers

From Daniel Verite
Subject Re: [HACKERS] export import bytea from psql
Date
Msg-id 210f4991-b263-461c-8124-ff509427d73a@manitou-mail.org
Whole thread Raw
In response to Re: [HACKERS] export import bytea from psql  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [HACKERS] export import bytea from psql  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
    Pavel Stehule wrote:

> It is similar to my first or second proposal - rejected by Tom :(

Doesn't it differ? ISTM that in the patches/discussion related to:
https://commitfest.postgresql.org/11/787/
it was proposed to change \set in one way or another,
and also in the point #1 of this present thread:

> > 1. using psql variables - we just need to write commands \setfrom
> > \setfrombf - this should be very simple implementation. The value can be
> > used more times. On second hand - the loaded variable can hold lot of
> > memory (and it can be invisible for user).


My comment is: let's not change \set or even create a variant
of it just for importing verbatim file contents, in text or binary,
because interpolating psql variables differently in the query itself
is all we need.


Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Cached plans and statement generalization
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] eval_const_expresisions and ScalarArrayOpExpr