Thread: Whassup with this? (create table .... like ... fails)

Whassup with this? (create table .... like ... fails)

From
Karl Denninger
Date:
childrensjustice=# create table petition_new like petition_bail;
ERROR:  syntax error at or near "like"
LINE 1: create table petition_new like petition_bail;                         

-- 
Karl Denninger (karl@denninger.net)
http://www.denninger.net






Re: Whassup with this? (create table .... like ... fails)

From
Stephan Szabo
Date:
On Sat, 19 Jul 2008, Karl Denninger wrote:

> childrensjustice=# create table petition_new like petition_bail;
> ERROR:  syntax error at or near "like"
> LINE 1: create table petition_new like petition_bail;

As far as I can tell from the syntax description, the LIKE petition_bail
should be in the table definition parens, so probablycreate table petition_new (like petition_bail);