On 07/24/12 1:28 PM, jkells wrote:
> from psql
> I have tried several ways including creating a function to read a file
> without any success but basically I want to do something like the
> following from a bash shell
>
> psql <connection information> -c "insert into x (ID, load_date, image)
> values ($PID,clock_timestamp()::timestamp(0), copy from '/tmp/$FN' with
> binary);"
>
> Any help would be greatly appreciated
use a proper programming language that can read files and insert BYTEA
data. shell + psql just won't cut it. I'd suggest perl or python or
java or whatever.
--
john r pierce N 37, W 122
santa cruz ca mid-left coast