Inserting .png file into bytea column - Mailing list pgsql-admin

From Ferrell, Denise D CTR NSWCDD, H11
Subject Inserting .png file into bytea column
Date
Msg-id 2BC18916DE4BF141AC1EFC55CE2CAE7D111B8C62@NAEANRFKXM01V.nadsusea.nads.navy.mil
Whole thread Raw
Responses Re: Inserting .png file into bytea column  (Achilleas Mantzios <achill@matrix.gatewaynet.com>)
Re: Inserting .png file into bytea column  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-admin
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.

Denise Ferrell

Attachment

pgsql-admin by date:

Previous
From: Atilla Balci
Date:
Subject: pgAdmin3
Next
From: "Campbell, Lance"
Date:
Subject: postgresql.conf