Re: Alter definition of a column

Поиск
Список
Период
Сортировка
От Shoaib Mir
Тема Re: Alter definition of a column
Дата
Msg-id bf54be870701192228l27722a8em127653c74063aa51@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Alter definition of a column  ("Kelly Burkhart" <kelly.burkhart@gmail.com>)
Ответы Re: Alter definition of a column  ("Kelly Burkhart" <kelly.burkhart@gmail.com>)
Список pgsql-general
Дерево обсуждения
Should help --> ALTER TABLE tablename ALTER columname TYPE text;

----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/20/07, Kelly Burkhart <kelly.burkhart@gmail.com> wrote:
On 1/19/07, Martijn van Oosterhout <kleptog@svana.org> wrote:
>
> ALTER TABLE, to be correct, actually has to check the entire table to
> make sure it's ok. By doing it directly you're basically telling the DB
> it's OK.
>
> For making a varchar column longer it's safe though, and the easiest way.

Is it possible to use a similar method to change a varchar(n) to text
with no length constraint?

-K

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

В списке pgsql-general по дате отправления:

Предыдущее
От: "Shoaib Mir"
Дата:
Сообщение: Re: Installing Postegres side-by-side with M$ SQL server
Следующее
От: "Mikael Carneholm"
Дата:
Сообщение: Re: Help : Microsoft SQL Server equivalents in PostGreSQL