That doesn’t help. Even this CREATE TABLE tse_history_old (LIKE tse_history) gives an error
From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]
On Behalf Of John R Pierce
Sent: Wednesday, March 26, 2014 2:43 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: 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
