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 200006082329.e58NTUb02892@piglet.dstc.edu.au
Whole thread Raw
List pgsql-sql
[I asked this question on the "interfaces" list, but nobody answered ...]

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: Brian Powell
Date:
Subject: Help with inserts into Views
Next
From: Oliver Graf
Date:
Subject: RE: SQL 'Case When...'