Re: CREATE TABLE docs question

From: "Milen A(dot) Radev" <milen(at)radev(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: CREATE TABLE docs question
Date: 2009-02-17 11:57:32
Message-ID: gne8nc$mbc$1@ger.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Michael Monnerie написа:
> http://www.postgresql.org/docs/8.3/interactive/sql-createtable.html
>
> Reading the docs, the following should work:
>
> CREATE TABLE messageblks like dbmail_messageblks;
>
> but it says:
> ERROR: syntax error at or near "like"
> ZEILE 1: CREATE TABLE messageblks like dbmail_messageblks;
> ^
>
> What's my error?

Should be "CREATE TABLE messageblks (like dbmail_messageblks);"

--
Milen A. Radev

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2009-02-17 13:49:40 Re: CREATE TABLE docs question
Previous Message Michael Monnerie 2009-02-17 11:37:50 CREATE TABLE docs question