From: Greg Spiegelberg <gspiegelberg@cranel.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@postgresql.org
Subject: Re: OID assistance
Date: Fri, 18 Feb 2005 10:54:15 -0500
Message-ID: <42160FA7.8030607@cranel.com> (raw)
In-Reply-To: <18094.1108738956@sss.pgh.pa.us>
References: <3482911A44F0C44EABC658E136A2E8073E974A@colmail01.cranel.local>
<17940.1108738126@sss.pgh.pa.us>
<42160081.5050205@cranel.com>
<18094.1108738956@sss.pgh.pa.us>
Tom Lane wrote:
>
> Exactly how are you "using OIDs to store files"? Do you mean you're
> using large objects?
The table is
Table "public.imgs"
Column | Type | Modifiers
----------+--------+------------------------------------------------------
id | bigint | not null default nextval('public.imgs_id_seq'::text)
file | text |
contents | oid |
Indexes: imgs_pkey primary key btree (id)
Data is loaded using INSERT's.
insert into imgs values (1,'/path/to/myfile',lo_import('/path/to/myfile'));
Greg
--
Greg Spiegelberg
Product Development Manager
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: gspiegelberg@cranel.com
Technology. Integrity. Focus.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: gspiegelberg@cranel.com, tgl@sss.pgh.pa.us
Subject: Re: OID assistance
In-Reply-To: <42160FA7.8030607@cranel.com>
References: <3482911A44F0C44EABC658E136A2E8073E974A@colmail01.cranel.local> <17940.1108738126@sss.pgh.pa.us> <42160081.5050205@cranel.com> <18094.1108738956@sss.pgh.pa.us> <42160FA7.8030607@cranel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox