Re: BLOBS : how to remove them totally

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Nilabhra Banerjee <nil_ban(at)yahoo(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: BLOBS : how to remove them totally
Date: 2003-12-18 12:10:46
Message-ID: 3FE19946.9010005@oopsware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message venkat j 2003-12-18 12:14:37 dblink_connect fails
Previous Message Markus Rebbert 2003-12-18 12:10:22 Which file system do i have to choose?