Skip site navigation (1) Skip section navigation (2)

rename a table name

From: Bai Yan <baiyan(at)ece(dot)ogi(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: rename a table name
Date: 2002-03-19 05:57:13
Message-ID: Pine.GSO.4.21.0203182153150.24017-100000@spruce.ece.ogi.edu (view raw or flat)
Thread:
Lists: pgsql-novice
Hello all,

I am new for postgresql and have a big bunch of problems.

I create a table named 'action-test' but now I want to change the name to
'action', ALTER TALBE command doesn't help and I didn't find a command as
'rename'.

How can I create a table copied from another table, say, both have the same
structure and content?

Thanks a lot,

Yan Bai



In response to

Responses

pgsql-novice by date

Next:From: Henshall, Stuart - WCPDate: 2002-03-19 10:57:05
Subject: Re: rename a table name
Previous:From: Trevor MorrisonDate: 2002-03-19 05:09:44
Subject: Fwd: Query results

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group