From: | "Carlos Cobos" <clcobosu(at)hotmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | |
Date: | 2002-12-05 13:16:07 |
Message-ID: | F2037YWhRTh0wBcxiMe00016df6@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ligia Pimentel | 2002-12-05 15:15:48 | Re: |
Previous Message | Macropac | 2002-12-05 10:40:55 | Fw: unsubscribe |