View Single Post

   
  #8 (permalink)  
Old 04-12-2008, 05:37 AM
Jonah H. Harris
 
Posts: n/a
Default Re: ALTER TABLE RENAME column

On 11/17/06, Mario Weilguni <mario.weilguni@icomedias.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@enterprisedb.com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote