| From: | "Hall, Samuel L (Sam)" <sam(dot)hall(at)alcatel-lucent(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PgAdmin errors |
| Date: | 2014-03-26 19:58:45 |
| Message-ID: | 69751890A64B3241A83BDB52A30BF29D1936F60C@US70UWXCHMBA02.zam.alcatel-lucent.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
That doesn't help. Even this CREATE TABLE tse_history_old (LIKE tse_history) gives an error
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: Wednesday, March 26, 2014 2:43 PM
To: pgsql-general(at)postgresql(dot)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
--
john r pierce 37N 122W
somewhere on the middle of the left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2014-03-26 20:01:12 | Re: Auditing Code - Fortify |
| Previous Message | John R Pierce | 2014-03-26 19:43:16 | Re: PgAdmin errors |