Skip site navigation (1) Skip section navigation (2)

Re: Bytea question

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "Chris Hoover" <revoohc(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Bytea question
Date: 2007-04-11 13:32:31
Message-ID: 1d219a6f0704110632k7448f319i7cecbb7899b1d959@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
What I am needing to do is to store a file I receive, say file1.dat.  I want
to store file1.dat into a bytea field so we can always go back and retrieve
the original file to verify if needed.  However, I also need to process the
data that is in file1.dat (1234 johnny 1254.12).  When I load file1.dat into
the bytea field, I just have a large escaped record that represents the
file.  What I am hoping is possible is to have postgres look into file1.dat's
byte a field and be able to read the data in file1.dat (assuming it's a
simple text file).  That way, the database can do all of the heavy lifting
and loading.

so.

Insert file1.dat into a bytea field of table a.
Table a's insert trigger fires, and postgres looks at the bytea field and
see's file1.dat and its contents of "1234 johnny 1254.12".
Trigger runs logic on data and loads into appropriate tables

I hope this makes sense.

Chris


On 4/11/07, Chris Hoover <revoohc(at)gmail(dot)com> wrote:
>
> No, I need to store the entire file as received into the database.
>
> Chris
>
> On 4/11/07, Alvaro Herrera < alvherre(at)commandprompt(dot)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/
> > PostgreSQL Replication, Consulting, Custom Development, 24x7 support
> >
>
>

In response to

pgsql-admin by date

Next:From: Mike GoldnerDate: 2007-04-11 13:40:13
Subject: Re: Bytea question
Previous:From: Alvaro HerreraDate: 2007-04-11 13:22:58
Subject: Re: Bytea question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group