Modifying column size
| От | Susan Lane |
|---|---|
| Тема | Modifying column size |
| Дата | |
| Msg-id | aha06h$14q9$1@news.hub.org обсуждение исходный текст |
| Ответы |
Re: Modifying column size
Re: Modifying column size Re: Modifying column size |
| Список | pgsql-general |
I was wondering if anyone here knew of a way to modify the size of a column
in Postgres. In Oracle, you can use the following syntax:
alter table usrs modify passwd varchar2(32); (For Postgres, I changed
the datatype to varchar)
But, when I try this in psql, it doesn't like the modify keyword. I looked
in the documentation, and I found a doc note that someone else had tried
this as well to no avail. Anybody know what is the correct syntax or if
this can even be done in Postgres?
Thanks!
--
Susan Lane
DPN, Incorporated
4631 Spring Mountain Road
Las Vegas, NV 89102
Email suel@dpn.com
Ph. (702) 873-3282
Fax (702) 873-3913
http://www.dpn.com
В списке pgsql-general по дате отправления: