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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
