alter table table add column
От | Ronald Rojas |
---|---|
Тема | alter table table add column |
Дата | |
Msg-id | 1185855587.28634.6.camel@localhost обсуждение исходный текст |
Ответы |
Re: [NOVICE] alter table table add column
Re: alter table table add column |
Список | pgsql-general |
Hi,
Anybody knows how to add column with reference to BEFORE or AFTER any given column? Let say here's my table structure:
Column | Type | Modifiers
----------+-------------------+-----------
surname | character varying |
lastname | character varying |
address | character varying |
And, I want to add the field name age with type integer after lastname OR before the address field. How to I do that?
I would really appreciate your response.
Thanks in advance.
Anybody knows how to add column with reference to BEFORE or AFTER any given column? Let say here's my table structure:
Column | Type | Modifiers
----------+-------------------+-----------
surname | character varying |
lastname | character varying |
address | character varying |
And, I want to add the field name age with type integer after lastname OR before the address field. How to I do that?
I would really appreciate your response.
Thanks in advance.
================================================================================================== Ronald Rojas Systems Administrator Linux Registered User #427229 ================================================================================================== Arnold's Laws of Documentation:(1) If it should exist, it doesn't.(2) If it does exist, it's out of date.(3) Only documentation for useless programs transcends the first two laws. |
В списке pgsql-general по дате отправления: