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