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

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Karl Denninger <karl(at)denninger(dot)net>
Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Whassup with this? (create table .... like ... fails)
Date: 2008-07-20 03:55:53
Message-ID: 20080719204718.L62726@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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);

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Milan Oparnica 2008-07-20 13:23:44 Re: PERSISTANT PREPARE (another point of view)
Previous Message Karl Denninger 2008-07-20 03:15:30 Whassup with this? (create table .... like ... fails)