| From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
|---|---|
| To: | "Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jim Nasby" <decibel(at)decibel(dot)org>, "PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: ALTER TABLE RENAME column |
| Date: | 2006-11-17 15:26:41 |
| Message-ID: | 36e682920611170726g4ff918ccu23284c2bb754a4b3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 11/17/06, Mario Weilguni <mario(dot)weilguni(at)icomedias(dot)com> wrote:
> Sounds like this is not done, at least not renaming sequencens and constraints, or am I wrong here?
To rename a sequence or a table:
ALTER TABLE yo_table RENAME TO yo_new_table;
ALTER TABLE yo_sequence RENAME TO yo_new_sequence;
Or am I mistaken?
--
Jonah H. Harris, Software Architect | phone: 732.331.1300
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 2nd Floor | jharris(at)enterprisedb(dot)com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jonah H. Harris | 2006-11-17 15:27:39 | Re: ALTER TABLE RENAME column |
| Previous Message | Kevin Grittner | 2006-11-17 15:25:57 | Re: Frequent Update Project: Design Overview |