Skip site navigation (1) Skip section navigation (2)

Re: Postgres blob question - insert from basic.

From: "Jean-Yves F(dot) Barbier" <12ukwn(at)gmail(dot)com>
To: rterry(at)pacific(dot)net(dot)au
Cc: PostgreSQL Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Postgres blob question - insert from basic.
Date: 2009-11-23 14:05:20
Message-ID: 4B0A96A0.2050904@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
richard terry a écrit :
> I'm confused about permissions to use lo_import/export:
...

got the same on command line as a user: must be SU to use lo_import.

but why don't U use a BYTEA (upper size limit is 1GB instead of 2GB,
but I doubt U have such large objects).

on command line, it works as a user:
INSERT INTO fruit ('tst', '/tmp/australia_land_of_dragons.png');
INSERT 0  1

JY
-- 
Any girl who believes that the way to a man's heart is through
his stomach is obviously setting her standards too high.

In response to

Responses

pgsql-novice by date

Next:From: Mike EllsworthDate: 2009-11-23 15:01:59
Subject: Anonymous code blocks
Previous:From: richard terryDate: 2009-11-23 11:11:01
Subject: Postgres blob question - insert from basic.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group