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

Bytea question

From: "Chris Hoover" <revoohc(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Bytea question
Date: 2007-04-11 13:02:47
Message-ID: 1d219a6f0704110602n5b9fe58dy34e05008b9bff0be@mail.gmail.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2007-04-11 13:09:04
Subject: Re: Bytea question
Previous:From: Peter ElmersDate: 2007-04-11 09:12:07
Subject: Re: Problems with precompiled pgsql on mac

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