Is it possible to "truncate" a LOB? - Mailing list pgsql-sql

From Stephen Crawley
Subject Is it possible to "truncate" a LOB?
Date
Msg-id 200006060035.e560Zn504797@piglet.dstc.edu.au
Whole thread Raw
List pgsql-sql
Suppose that I have created a LOB, written a bunch of data to it, and 
committed.

Is it now possible to rewrite the LOB to contain a lesser amount of data?
In other words can I do the equivalent of UNIX open(..., O_WRONLY | O_TRUNC) 
or ftruncate(...) on a LOB?

Or am I forced to delete the existing LOB and create a new one if I want
to shrink the size of the stored data?

-- Steve








pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Vacuum problem in my system ?
Next
From:
Date:
Subject: moving DB