Re:

try...

alter table prueba add column id varchar(15);

remember, for some reason, you can only add columns
one by one.

Good Luck.

Ligia Pimentel

--- Carlos Cobos <clcobosu@hotmail.com> wrote:
>
>
> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com