Re: Deleting BLOBs - Mailing list pgsql-general

From Neanderthelle Jones
Subject Re: Deleting BLOBs
Date
Msg-id Pine.LNX.4.64.1208130924180.30314@calypso.view.net.au
Whole thread Raw
In response to Re: Deleting BLOBs  (Neanderthelle Jones <elle@view.net.au>)
List pgsql-general
On Mon, 13 Aug 2012, Neanderthelle Jones wrote:

>
> $ for i in $(psql -q -t -U elle -d my_db \
>  -c "SELECT raster FROM images where raster > 0"); do
>  echo $i
>  psql -q -U elle -d my_db -c "SELECT lo_unlink($i)"
> done

"BEGIN; SELECT lo_unlink($i); COMMIT" makes no difference.


pgsql-general by date:

Previous
From: Neanderthelle Jones
Date:
Subject: Re: Deleting BLOBs
Next
From: Tom Lane
Date:
Subject: Re: Deleting BLOBs