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 ...

testing, I find that using the word "LIKE" always causes errors

"PostgreSQL 9.3.0 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro 
4.6.3-1ubuntu5) 4.6.3, 64-bit"
Running PgAdmin on Windows 7 64 bit

What I need to do is copy a table completely, all data, indexes, keys

Reply via email to