Postgres Pro
Downloads
Home   >   mailing lists

alter table modify column ... - Mailing list pgsql-general

From Evelio Martínez
Subject alter table modify column ...
Date
Msg-id 006d01c1678d$550dc520$4ecd72c3@testanet.com
Whole thread Raw
List pgsql-general
Tree view
 
Hi!
 
I would like to know if there is anything similar to Informix-sql sintax to modify a column type.
 
I want to change a column from varchar(40) to varchar(40)[].
 
Do I have to make a stored procedure?
Is there any way to cast a varchar to a _varchar.
 
Something similar to:
 
create table kk4 as  select numero, idproy, foto, '\'{"' || nombre::_varchar  || '"}\'' as nombre, descrip from proy_foto;
ERROR:  Cannot cast type 'varchar' to '_varchar'
 
Any idea will be appreciated.
 
Thanks in advance
------------
Evelio Martínez

pgsql-general by date:

Previous
From: Gordan Bobic
Date:
Subject: Performance Question Followup No.2
Next
From: "Andy Hallam"
Date:
Subject: Re: LIKE predicate and '\' character