That doesn't help. Even this CREATE TABLE tse_history_old (LIKE tse_history) 
gives an error

From: pgsql-general-ow...@postgresql.org 
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
Sent: Wednesday, March 26, 2014 2:43 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PgAdmin errors

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

Reply via email to