On 3/26/2014 1:07 PM, Hall, Samuel L (Sam) wrote:
ERROR: syntax error at or near "LIKE"
LINE 2: CREATE TABLE tse_history_old (LIKE tse_history)
thats the syntax from
http://www.postgresql.org/docs/current/static/sql-createtable.html
try it in psql instead of pgadmin ?
earlier, you menti
Hall, Samuel L (Sam) wrote:
> ERROR: syntax error at or near "LIKE"
> LINE 2: CREATE TABLE tse_history_old (LIKE tse_history)
>
> ^
Note it says this is on line 2. What have you got in the previous line?
(psql has \p
On 03/26/2014 02:13 PM, Hall, Samuel L (Sam) wrote:
Yes
"PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit"
So what happens when you run the command from psql ?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general m
gresql.org
Subject: Re: [GENERAL] PgAdmin errors
"Hall, Samuel L (Sam)" writes:
> ERROR: syntax error at or near "LIKE"
> LINE 2: CREATE TABLE tse_history_old (LIKE tse_history)
You're certain the server you're talking to is 9.3
"Hall, Samuel L (Sam)" writes:
> ERROR: syntax error at or near "LIKE"
> LINE 2: CREATE TABLE tse_history_old (LIKE tse_history)
You're certain the server you're talking to is 9.3?
("SELECT version()" is a good way to be sure.)
regards, tom lane
--
Sent via pgsql-gene
ierce
Sent: Wednesday, March 26, 2014 3:02 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PgAdmin errors
On 3/26/2014 12:58 PM, Hall, Samuel L (Sam) wrote:
That doesn't help. Even this CREATE TABLE tse_history_old (LIKE tse_history)
gives an error
the exact same error ?
--
On 3/26/2014 12:58 PM, Hall, Samuel L (Sam) wrote:
That doesn't help. Even this CREATE TABLE tse_history_old (LIKE
tse_history) gives an error
the exact same error ?
--
john r pierce 37N 122W
somewhere on the middle of the left coast
t: 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_hi
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 ...
f
