[SQL] Whassup with this? (create table .... like ... fails)

2008-07-19 Thread Karl Denninger 

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 ([EMAIL PROTECTED])
http://www.denninger.net





--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

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

2008-07-19 Thread Stephan Szabo 

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 probably
 create table petition_new (like petition_bail);

-- 
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql