SQL command Error: "create table ... Like parentTable including defaults"

Поиск
Список
Период
Сортировка
От Ying Lu
Тема SQL command Error: "create table ... Like parentTable including defaults"
Дата
Msg-id 42974157.201@cs.concordia.ca
обсуждение исходный текст
Ответы Re: SQL command Error: "create table ... Like parentTable
Re: SQL command Error: "create table ... Like parentTable including defaults"
Список pgsql-sql
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 по дате отправления:

Предыдущее
От: Tony Wasson
Дата:
Сообщение: Re: 3 tables, slow count(*), order by Seq Scan in Query Plan
Следующее
От: Bricklen Anderson
Дата:
Сообщение: Re: SQL command Error: "create table ... Like parentTable