BUG #4650: can't specify table schema in CREATE TABLE AS
The following bug has been logged online:
Bug reference: 4650
Logged by: Thue Janus Kristensen
Email address: thuejk@gmail.com
PostgreSQL version: 8.3.5
Operating system: Linux
Description: can't specify table schema in CREATE TABLE AS
Details:
According to
http://www.postgresql.org/docs/8.3/interactive/sql-createtableas.html , the
following should work:
CREATE TABLE test(a INT) AS (SELECT 1);
However:
k3_dev_tjk=> CREATE TABLE test(a INT) AS (SELECT 1);
ERROR: syntax error at or near "AS"
LINE 1: CREATE TABLE test(a INT) AS (SELECT 1);
It works if I drop the table schema:
k3_dev_tjk=> CREATE TABLE test AS (SELECT 1);
SELECT
On Thu, Feb 12, 2009 at 6:22 PM, Thue Janus Kristensen <thuejk@gmail.com>wrote:
The following bug has been logged online:
Bug reference: 4650
Logged by: Thue Janus Kristensen
Email address: thuejk@gmail.com
PostgreSQL version: 8.3.5
Operating system: Linux
Description: can't specify table schema in CREATE TABLE AS
Details:According to
http://www.postgresql.org/docs/8.3/interactive/sql-createtableas.html ,
the
following should work:CREATE TABLE test(a INT) AS (SELECT 1);
However:
k3_dev_tjk=> CREATE TABLE test(a INT) AS (SELECT 1);
ERROR: syntax error at or near "AS"
LINE 1: CREATE TABLE test(a INT) AS (SELECT 1);It works if I drop the table schema:
k3_dev_tjk=> CREATE TABLE test AS (SELECT 1);
SELECT
Look closely, it says just column names, not their datatypes. So the command
should be:
CREATE TABLE test(a) AS (SELECT 1);
Best regards,
--
gurjeet[.singh]@EnterpriseDB.com
singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
Mail sent from my BlackLaptop device