Re: Deleting BLOBs

From: Neanderthelle Jones <elle(at)view(dot)net(dot)au>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deleting BLOBs
Date: 2012-08-12 23:55:55
Message-ID: Pine.LNX.4.64.1208130924180.30314@calypso.view.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-08-13 00:13:07 Re: Deleting BLOBs
Previous Message Neanderthelle Jones 2012-08-12 23:28:16 Re: Deleting BLOBs