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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
