[SQL] How to escape a memo field as a binary value in postgresql

2007-10-12 Thread rdyes
I want to take the value of my memo field in Paradox and insert/update the 
value of a binary field in my backend postgresql database.  How would I 
write this sql statement

for the sake of this example lets say the field name is pmemo in paradox 
and the is bymemo  a bytea field in Postgresql database.


[SQL] Unescaping text or binary file

2008-01-14 Thread RDyes
IN your sql statements you use e to escape data going into a binary, or 
text field.  How do you unescape this same data?
Richmond H. Dyes
Monroe Community Hospital
760-6213