From: Alvaro Herrera <alvherre@commandprompt.com>
To: Chris Hoover <revoohc@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Bytea question
Date: Wed, 11 Apr 2007 09:22:58 -0400
Message-ID: <20070411132258.GF4896@alvh.no-ip.org> (raw)
In-Reply-To: <1d219a6f0704110617y31780a75q8f783893acb6ef07@mail.gmail.com>
References: <1d219a6f0704110602n5b9fe58dy34e05008b9bff0be@mail.gmail.com>
<20070411130904.GD4896@alvh.no-ip.org>
<1d219a6f0704110617y31780a75q8f783893acb6ef07@mail.gmail.com>
Chris Hoover escribió:
> No, I need to store the entire file as received into the database.
Then you original question does not make any sense to me, because if you
pass the entire file content, why would Postgres *not* be able to read
it?
> On 4/11/07, Alvaro Herrera <alvherre@commandprompt.com> wrote:
> >
> >Chris Hoover escribió:
> >> Hopefully a quick question.
> >>
> >> If I store a file into a bytea field, is there anyway for postgres to
> >read
> >> the contents of the file?
> >
> >When you say "store a file", do you mean "store a filename"?
> >
> >> Here is my scenario:
> >>
> >> Receive text file
> >> insert file into bytea field
> >> insert trigger fires
> >> - read file contents
> >> - post contents into production tables
> >>
> >> Is this at all possible, or am I going to need to store the original
> >file
> >> and store/pass the file contents?
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
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 using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@commandprompt.com, revoohc@gmail.com
Subject: Re: Bytea question
In-Reply-To: <20070411132258.GF4896@alvh.no-ip.org>
* 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