Casting bytea to varchar
От
Rajagopalan, Jayashree
Тема
Casting bytea to varchar
Дата
Msg-id
672B315321EBEC4CA4B5627D112E0896067F86D01E@MX25A.corp.emc.com
Список
Дерево обсуждения
Casting bytea to varchar "Rajagopalan, Jayashree" <Jayashree.Rajagopalan@emc.com>
Re: Casting bytea to varchar Albe Laurenz <laurenz.albe@wien.gv.at>
Re: Casting bytea to varchar Tom Lane <tgl@sss.pgh.pa.us>
Re: Casting bytea to varchar Albe Laurenz <laurenz.albe@wien.gv.at>
Hi:
I’m relatively new to postgres:
I’ve to alter a column which is of datatype bytea to varchar(255).
I used this:
ALTER TABLE tablename ALTER COLUMN columname TYPE varchar(255);
But I’m really not sure, if the value is casted properly.
Is there a way to explicity to cast the value, while altering a columns.
Example sql are welcome.
Thanks
Jayashree
В списке pgsql-admin по дате отправления
