On 09/22/2018 06:00 AM, Andreas Kretschmer wrote:
Am 22.09.2018 um 02:28 schrieb Rob Sargent:
However, I get into deep dodo when I try redirecting psql output such as
select ld from gt.ld\g /tmp/regen.file
works for me if i start psql with -t -A -o /path/to/file
(pg 10.5, but psql f
Am 22.09.2018 um 02:28 schrieb Rob Sargent:
However, I get into deep dodo when I try redirecting psql output such as
select ld from gt.ld\g /tmp/regen.file
works for me if i start psql with -t -A -o /path/to/file
(pg 10.5, but psql from 11beta3)
Regards, Andreas
--
2ndQuadrant - The
> On Sep 21, 2018, at 7:59 PM, Andres Freund wrote:
>
>> On 2018-09-21 18:28:37 -0600, Rob Sargent wrote:
>> "/tmp/regen.file" gets very large, very fast and I have to
>> pg_terminate_backend. Tried this three times, once using "\o test.blob"
>> instead.
>>
>> h009357:loader$ ls -ltr
>>
On 2018-09-21 18:28:37 -0600, Rob Sargent wrote:
> "/tmp/regen.file" gets very large, very fast and I have to
> pg_terminate_backend. Tried this three times, once using "\o test.blob"
> instead.
>
>h009357:loader$ ls -ltr
>total 2048
>-rwxr-xr-x 1 u0138544 camplab 10002460672 Sep 21 1
Playing around with files-in-text-field. I can happily slam a 10M file
into a text field in a table defined as
gtdb=# \d gt.ld
Table "gt.ld"
Column | Type | Collation | Nullable | Default
--+--+---+--+-
id