Bytea question - Mailing list pgsql-admin

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?

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?


Thanks,

Chris