CREATE TABLE new_table AS SELECT * FROM old_table
You can also use SELECT INTO, but I believe SQL 92 uses it for a different
purpose, so is probably best avoided.
Hope this helps,
- Stuart
> -----Original Message-----
> From: Bai Yan [mailto:baiyan@ece.ogi.edu]
> Sent: 19 March 2002 05:57
> To: pgsql-novice@postgresql.org
> Subject: [NOVICE] rename a table name
>
>
> 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
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>