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@xxxxxxxxxxxxxxxxx> 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.
