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