Displaying the table definition on Postgres

mkrishnanand · 08-17-2004, 10:54 PM

Hi,

I want to create a table on Postgres based on another table and I did that using create table as select * .... but my requirement is I want to change the datatype of one particular column on the newly created table whether thats possible. If yes means how to change that. Any help is appreciated.

Regds

Krishna

Mara · 08-18-2004, 03:51 PM

alter table change column_name column_name varchar(150)
If you want to change the datatype to varchar(150).

I'm also moving this thread to the Programming forum, as that's the right place for SQL related questions.