Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 23B6E6330E9 for ; Tue, 17 Feb 2009 07:57:54 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 54825-05 for ; Tue, 17 Feb 2009 07:57:50 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by mail.postgresql.org (Postfix) with ESMTP id DE1B5632E5A for ; Tue, 17 Feb 2009 07:57:50 -0400 (AST) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1LZOa9-0008Ph-F3 for pgsql-admin@postgresql.org; Tue, 17 Feb 2009 11:57:45 +0000 Received: from gw-sf.securax.net ([89.253.129.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 17 Feb 2009 11:57:45 +0000 Received: from milen by gw-sf.securax.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Tue, 17 Feb 2009 11:57:45 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: CREATE TABLE docs question Date: Tue, 17 Feb 2009 13:57:32 +0200 Lines: 19 Message-ID: References: <200902171237.54372@zmi.at> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: gw-sf.securax.net User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) In-Reply-To: <200902171237.54372@zmi.at> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200902/114 X-Sequence-Number: 31335 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