Postgres Pro
Downloads
Home   >   mailing lists

SQL command Error: "create table ... Like parentTable including defaults" - Mailing list pgsql-sql

From Ying Lu
Subject SQL command Error: "create table ... Like parentTable including defaults"
Date
Msg-id 42974157.201@cs.concordia.ca
Whole thread Raw
Responses Re: SQL command Error: "create table ... Like parentTable  (Bricklen Anderson <BAnderson@PresiNET.com>)
Re: SQL command Error: "create table ... Like parentTable including defaults"  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Tree view 
Greetings,

I have a simple question about SQL command :

create table tableName1 LIKE parentTable   INCLUDING defaults ;


I was trying to create table "tableName1" with the same structure as 
"parentTable" without any data. I got a syntax error: 
'syntax error at or near "like" ... '

I guess there must be something wrong with my sql command, could 
somebody help?

Thanks a lot,
Emi

pgsql-sql by date:

Previous
From: Tony Wasson
Date:
Subject: Re: 3 tables, slow count(*), order by Seq Scan in Query Plan
Next
From: Bricklen Anderson
Date:
Subject: Re: SQL command Error: "create table ... Like parentTable