Re: CREATE TABLE docs question - Mailing list pgsql-admin

From Milen A. Radev
Subject Re: CREATE TABLE docs question
Date
Msg-id gne8nc$mbc$1@ger.gmane.org
Whole thread Raw
In response to CREATE TABLE docs question  (Michael Monnerie <michael.monnerie@is.it-management.at>)
Responses Re: CREATE TABLE docs question  (Michael Monnerie <michael.monnerie@is.it-management.at>)
List 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

pgsql-admin by date:

Previous
From: Michael Monnerie
Date:
Subject: CREATE TABLE docs question
Next
From: Michael Monnerie
Date:
Subject: Re: CREATE TABLE docs question