Postgres Pro
Downloads
Home   >   mailing lists

Re: BLOBS : how to remove them totally - Mailing list pgsql-general

From Bernd Helmle
Subject Re: BLOBS : how to remove them totally
Date
Msg-id 3FE19946.9010005@oopsware.de
Whole thread Raw
In response to BLOBS : how to remove them totally  (Nilabhra Banerjee <nil_ban@yahoo.co.uk>)
Responses Re: BLOBS : how to remove them totally  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Nilabhra Banerjee wrote:
> Hi,
>
> I am still not sure whether the BLOBS are actually
> stored in the database or they have the pointer to the
> database for that file in the filesystem. If I remove
> the files (sources) for BLOBS from the directories
> with the BLOB still hold the data ?
>
> Also one more very intriguing part is that if BLOBS
> are not deleted if we delete them from tables how to
> remove them ?
>

Here you can find an excellent description, how BLOBs in PostgreSQL can
be handled:

http://www.varlena.com/varlena/GeneralBits/44.php

> Regards
> N Banerjee
>

   Bernd

pgsql-general by date:

Previous
From: Markus Rebbert
Date:
Subject: Which file system do i have to choose?
Next
From: "Craig Stratton"
Date:
Subject: pqReadData() -- read() failed: errno=32