...

hi people !
I'm trying to change a structure of a table but I don't know how a use alter
table in psql but doesn´t work always give me a  parser error can you
explein how to do by the why pgadmin don't have a plugins to do that
[root@dns1 root]# su -l postgres
bash-2.05$ psql iutepalsc
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

iutepalsc=# create table prueba ("id" varchar(8));
CREATE
iutepalsc=# alter  table prueba column ("id" varchar(15));
ERROR:  parser: parse error at or near "column"
iutepalsc=#








_________________________________________________________________
MSN Fotos: la forma más fácil de compartir e imprimir fotos.
http://photos.msn.es/support/worldwide.aspx