Saturday, July 19, 2008

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

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 (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

No comments: