Re: Whassup with this? (Create table xxx like yyy fails)

From: Karl Denninger <karl(at)denninger(dot)net>
To: Douglas McNaught <doug(at)mcnaught(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Whassup with this? (Create table xxx like yyy fails)
Date: 2008-07-20 04:38:13
Message-ID: 4882C135.2010700@denninger.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Douglas McNaught wrote:
> On Sat, Jul 19, 2008 at 9:02 PM, Karl Denninger <karl(at)denninger(dot)net> wrote:
>
>> childrensjustice=# create table petition_bail like petition_white;
>> ERROR: syntax error at or near "like"
>> LINE 1: create table petition_bail like petition_white;
>>
>
> It's not super-easy to see from the docs, but I think you need parentheses:
>
> CREATE TABLE petition_bail (LIKE petition_white);
>
> -Doug
>
>
Aha.

Thank you.

Karl Denninger (karl(at)denninger(dot)net)
http://www.denninger.net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-07-20 04:43:35 Re: Initdb problem on debian mips cobalt: Bus error
Previous Message Douglas McNaught 2008-07-20 04:20:30 Re: Whassup with this? (Create table xxx like yyy fails)