Re: permission denied for large object 200936761 - Mailing list pgsql-general

From Andrus
Subject Re: permission denied for large object 200936761
Date
Msg-id ddd26ebf-b653-e6d1-c30c-f4b385031832@hot.ee
Whole thread Raw
In response to permission denied for large object 200936761  (Andrus <kobruleht2@hot.ee>)
List pgsql-general

Hi!
You can extract it with

 \lo_export 200936761 'somefile'

in psql and examine the file.

Ask the people who use that database!

Tried

root@c202-76:~# ./pgsqlkaiv.sh psql (12.2 (Debian 12.2-2.pgdg100+1))
Type "help" for help.

sba=#  \lo_export 200936761 'large200936761'
lo_export
sba=# \q

root@c202-76:~# ls -l large*
-rw-r--r-- 1 root root 0 veebr  2 10:45 large200936761

result file size is 0 .

Andrus.

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: count(*) vs count(id)
Next
From: Andrus
Date:
Subject: Re: permission denied for large object 200936761