[GENERAL] insert binary data into a table column with psql

2012-07-24 Thread jkells
I am running REDHAT 5.5 64 bit with PostgreSQL 8.4.7 64 bit. I am trying to load a binary file into a bytea column into a table without any luck from psql. On the linux server a script is looking for a file and if found would create a record into a table that contains a ID, date of load and the

Re: [GENERAL] General coding question

2011-12-20 Thread jkells
On Tue, 20 Dec 2011 13:32:32 -0500, David Johnston wrote: > -Original Message- > From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of jkells Sent: > Tuesday, December 20, 2011 12:33 PM To: pgsql-general@postgresql.org > Su

[GENERAL] General coding question

2011-12-20 Thread jkells
General coding question. Can I insert a text string into a character varying column that contains a \ as is, meaning no escaping of the character or is this a bad practice? I.e: Column data == description