Re: Deleting BLOBs

If i where you i would try:

select lo_unlink(rest) from image

but i'm never used this function...

Neanderthelle Jones <elle(at)view(dot)net(dot)au> hat am 12. August 2012 um 12:16
geschrieben:
> I'd like to delete all the image files from a table by issuing an
> interactive psql command. Given
>
> CREATE TABLE image (
> name text,
> rast oid
> );
>
> with most tuples having images in rast, wanna do something like
>
> => select lo_unlink('select rast from image');
>
> Can such a thing be done, and how? I guess I've forgotten the syntax.
>
> Or will an update that sets the oids to null or 0 work?
>
> (pgsql 9.1.2)
>
> Thanks.
>
> -
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general