On 19/11/2015 16:07, Ferrell, Denise D CTR NSWCDD, H11 wrote:
Good Morning All,
I am using PostgreSQL 9.3 on Linux Rehat...
I'm trying to insert an image (.png format) into a table of flags. I've tried the following but keep getting errors.
CREATE TABLE FLAGS (country_code text, flag bytea);
INSERT INTO flags VALUES ('AD', pg_read_file('/home/flags')::bytea);
Get the following error:
ERROR: absolute path not allowed
*********ERROR*************
ERROR: absolute path not allowed
SQL State: 42501
Any assistance would be greatly appreciated.
http://www.postgresql.org/docs/9.2/static/functions-admin.html#FUNCTIONS-ADMIN-GENFILE use
pg_read_binary_file(filename text [, offset bigint, length bigint])
as documented
Denise Ferrell
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt