Re: BLOBS : how to remove them totally

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