rename a table name - Mailing list pgsql-novice

From Bai Yan
Subject rename a table name
Date
Msg-id Pine.GSO.4.21.0203182153150.24017-100000@spruce.ece.ogi.edu
Whole thread Raw
In response to create remote table with sort of index...  ("Al-Haddad, Mohammad J" <mjalha@essex.ac.uk>)
Responses Re: rename a table name  ("Joel Burton" <joel@joelburton.com>)
List 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



pgsql-novice by date:

Previous
From: Trevor Morrison
Date:
Subject: Fwd: Query results
Next
From: Rob
Date:
Subject: Triggers in postgres