using pg_read_file read file in desktop PostgreSQL

Question

I wanted to how to read a file in my desk top using pg_read_file in PostgreSQL

pg_read_file(filename text [, offset bigint, length bigint])

my query

select pg_read_file('/root/desktop/new.txt' , 0 , 1000000);

error

ERROR:  absolute path not allowed

UPDATE

Answer 1

pg_read_file can read the files only from the data directory path, if you would like to know your data directory path use:

SHOW  data_directory;

I think that you can resolve you problem by looking to this post

Answer 2

If you're using psql you can use \lo_import to create a large object from a local file.

The pg_read_file tool only allows reads from server-side files.