Re: PgAdmin errors

[John R Pierce <pierce@xxxxxxxxxxxx>]

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