Got error on CREATE TABLE AS - Mailing list pgsql-general

From Jeff Lu
Subject Got error on CREATE TABLE AS
Date
Msg-id LIEBJAJMJFLPHGCPMEBGKEIPCEAA.jklcom@mindspring.com
Whole thread Raw
In response to Is there an internal timestamp on a table when it was created?  ("Jeff Lu" <jklcom@mindspring.com>)
Responses Re: Got error on CREATE TABLE AS (+Bug?)
List pgsql-general
Hi,

I'm getting parser error at or near AS

when try to copy a table using CREATE TABLE AS

Here what I have in the sql statement

CREATE TABLE employee_backup (id text UNIQUE, lastname text, firstname text,
phone text) AS SELECT * FROM employee

Can some body tell me what is wrong with the sql statement?

Thank you


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Libpq coding assistance
Next
From: "Command Prompt, Inc."
Date:
Subject: Re: Got error on CREATE TABLE AS (+Bug?)