Re: [ADMIN] Cast text to bytea

2003-12-03 Thread Alvar Freude
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, uups, why I wrote the originating mail to pgsql-admin? Sorry! - -- Godshall Michael <[EMAIL PROTECTED]> wrote: > Have you seen this? > http://www.postgresql.org/docs/current/static/datatype-binary.html yes, but this only describe the bytea

Re: [ADMIN] Cast text to bytea

2003-12-02 Thread Godshall Michael
Title: RE: [ADMIN] Cast text to bytea Have you seen this? http://www.postgresql.org/docs/current/static/datatype-binary.html Maybe you need some backslashes? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Alvar Freude Sent: Tuesday, December 02

[ADMIN] Cast text to bytea

2003-12-02 Thread Alvar Freude
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I want to change a column from text to bytea; since it seems that alter table can't change the column type, i have to add a temporary column and copy the data from the old one to the new, delete the old and rename the new. But it seems that Post