Inserting .png file into bytea column

From: "Ferrell, Denise D CTR NSWCDD, H11" <denise(dot)ferrell(dot)ctr(at)navy(dot)mil>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Inserting .png file into bytea column
Date: 2015-11-19 14:07:35
Message-ID: 2BC18916DE4BF141AC1EFC55CE2CAE7D111B8C62@NAEANRFKXM01V.nadsusea.nads.navy.mil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Campbell, Lance 2015-11-19 14:11:38 postgresql.conf
Previous Message Atilla Balci 2015-11-18 10:27:15 pgAdmin3