That doesn’t help. Even this CREATE TABLE tse_history_old (LIKE tse_history) gives an error
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@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
