help w/ a little naive brainstorming ...

From: OpenMacNews <OpenMacNews(at)speakeasy(dot)net>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: help w/ a little naive brainstorming ...
Date: 2005-03-25 23:16:12
Message-ID: 66CB571AAC24AB31CC0E96A9@tiedgar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi all,

i've two random, not-completely-disjointed questions that have arisen in a
recent, off-the-cuff discussion.

any/all initial pointers/comments would be much appreciated ... while i slog
through Google, etc. trying to learn more ...

(1) does pgsql have/plan an equivalent of Oracle's External Tables?
<http://www.oracle.com/technology/products/oracle9i/daily/sept19.html>

searching on 'postgresql "external tables"' i'm unclear as to whether we're
talking abt the "same fruit" here (apples & apples, ya know?).

(2) most (no, not all) email servers store message data as flat-file text,
organized in some admin-spec'd file-system directory hierarchy.

if i were to consider 'storing' those messages trees, instead, in a pgsql db, i
i mmediately/naively think of three possible options

(a) simple DB-stored references to flat file:/// locations
(b) pointers to external, actionable (parseable? writeable?) files in the FS
(c) messages stored, in their entirety as CLOBS and/or BLOBS in the DB
(d) messages converted into, say, XML, and stored in the DB
(e) message components parsed into individual fields, and stored as addressable
character and 'bytea' (a new one on me ...) data in pgsql tables

any thoughts/comments as to 'best approach' and why?

no, not at all well thought thru -- just brainstormin' .... so, flame away! ;-)

and, thanks =)

richard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-03-25 23:34:57 Re: help w/ a little naive brainstorming ...
Previous Message Terry Lee Tucker 2005-03-25 21:59:34 Re: pg_index question