Search Postgresql Archives

Re: Deleting BLOBs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux