Re: PgAdmin errors - Mailing list pgsql-general

From John R Pierce
Subject Re: PgAdmin errors
Date
Msg-id 53332DD4.6020209@hogranch.com
Whole thread Raw
In response to PgAdmin errors  ("Hall, Samuel L (Sam)" <sam.hall@alcatel-lucent.com>)
Responses Re: PgAdmin errors  ("Hall, Samuel L (Sam)" <sam.hall@alcatel-lucent.com>)
List pgsql-general
On 3/26/2014 12:32 PM, Hall, Samuel L (Sam) wrote:

When I try to run SQL from PgAdmin : CREATE TABLE tse_history_old LIKE tse_history INCLUDING ALL WITH OIDS

I get this  error

ERROR:  syntax error at or near "LIKE"

LINE 2: CREATE TABLE tse_history_old LIKE tse_history INCLUDING ALL ...


from the manual, it appears LIKE belongs in parenthesis.

CREATE TABLE tse_history_old (LIKE tse_history INCLUDING ALL) WITH OIDS



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-general by date:

Previous
From: Dev Kumkar
Date:
Subject: Auditing Code - Fortify
Next
From: "Hall, Samuel L (Sam)"
Date:
Subject: Re: PgAdmin errors