The following bug has been logged online: Bug reference: 4650 Logged by: Thue Janus Kristensen Email address: thu...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
