It sounds like you want to parse the contents of the bytea column within
a trigger/stored procedure. I haven't done this myself (I process the
bytea data in java as an input stream after retrieving it from
postgres), but you could probably use a FOR loop over the bytea column
and then use some combination of the Binary String Functions
(http://www.postgresql.org/docs/current/static/functions-binarystring.html) to process the file data.
Mike
On Wed, 2007-04-11 at 09:22 -0400, Alvaro Herrera wrote:
> 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?
>