Re: Inserting .png file into bytea column

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Inserting .png file into bytea column
Дата
Msg-id 564DDA56.7030809@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Inserting .png file into bytea column  ("Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil>)
Ответы Re: Inserting .png file into bytea column
Список pgsql-admin
Дерево обсуждения
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

В списке pgsql-admin по дате отправления: