decode(your_string,'escape') will convert text to bytea You can just use this as a sort of type cast, or: 1. Create a new bytea column in your table 2. Update the table, setting the newcolumn = decode(oldcolumn,'escape') 3. Drop the oldcolumn (or not)
TJ Date: Wed, 01 Feb 2006 10:04:36 +0000 From: Howard Cole <[EMAIL PROTECTED]> To: 'PgSql General' <pgsql-general@postgresql.org> Subject: Converting Text to Bytea Message-ID: <[EMAIL PROTECTED]> Hi, Can anyone tell me how to convert a text column to a bytea column? Thanks. Howard Cole www.selestial.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
