On Thu, Feb 23, 2006 at 01:24:43PM +0530, sandhya wrote: > Is there any possibility to delete /Unlink a group of large objects at a > time? > Please tell me .To test my application i have loaded somany files into > database. > Now i want to unlink all those objects.
You could call lo_unlink() in a query. Example: SELECT lo_unlink(loid) FROM (SELECT DISTINCT loid FROM foo) AS s; See also contrib/vacuumlo, which will automatically remove large objects that aren't referenced anywhere. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
