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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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