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@view.net.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general