On Fri, Feb 24, 2006 at 11:57:57AM +0530, sandhya wrote:
> In select lo_unlink(objid) from (select distinct objid from filetbl)AS s;
> the above query what is that 'S' stands for in AS 'S'
"s" is a table alias, which is required for a subquery. The choice
of "s" is arbitrary; it can be any valid
quot; <[EMAIL PROTECTED]>
Cc: "Postgres"
Sent: Thursday, February 23, 2006 8:58 PM
Subject: Re: [ADMIN] large object unlinking
> On Thu, Feb 23, 2006 at 01:24:43PM +0530, sandhya wrote:
> > Is there any possibility to delete /Unlink a group of large objects at
a time?
>
On Thu, Feb 23, 2006 at 01:24:43PM +0530, sandhya wrote:
> Is there any possibility to delete /Unlink a group of large objects at a
> time?
> Please tell me .To test my application i have loaded somany files into
> database.
> Now i want to unlink all those objects.
You could call lo_unlink() i
hi...
Is there any possibility to delete /Unlink a group of
large objects at a time?
Please tell me .To test my application i have loaded somany
files into database.Now i want to unlink all those objects.
Please help me in doing this...
Thanks,
Sandhya
Hi,
I'm planing a file system type application for postgres, reading the
docs a question arise:
shall I put the files as large objects in the db, or kept them separately?
Reading the docs it seems to me, that large objects can hold data up to
2GB in size. Is this still true, or will that restrict
Martijn de Munnik <[EMAIL PROTECTED]> writes:
> and want to migrate from 7.0.x to 7.1.x and read some instructions. As far as
> i can see the disk files are not compatible so I need to do a pg_dumpall and
> restore it in the new database. Buw what about the Large objects in the
> databases (imag
Hi,
and want to migrate from 7.0.x to 7.1.x and read some instructions. As far as
i can see the disk files are not compatible so I need to do a pg_dumpall and
restore it in the new database. Buw what about the Large objects in the
databases (images etc) the are not in the backup?
Is there a wa
Hi! , I want to ask you about large objects or
BLOBs
I need to know the size of a large object that
I have already know its indice number.
For example ,
One of my large objects in my database is
indicated with xinv223345 and
xinc223345
if I use this
command
select lo_export(22334
