On Thu, Feb 12, 2009 at 6:22 PM, Thue Janus Kristensen <thu...@gmail.com>wrote:
> > 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 > 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[.sin...@enterprisedb.com singh.gurj...@{ gmail | hotmail | indiatimes | yahoo }.com EnterpriseDB http://www.enterprisedb.com Mail sent from my BlackLaptop device
