| From: | "Hall, Samuel L (Sam)" <sam(dot)hall(at)alcatel-lucent(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | PgAdmin errors |
| Date: | 2014-03-26 19:32:33 |
| Message-ID: | 69751890A64B3241A83BDB52A30BF29D1936F5B6@US70UWXCHMBA02.zam.alcatel-lucent.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2014-03-26 19:39:41 | Re: To monitor the number of PostgreSQL database connections? |
| Previous Message | Tim Spencer | 2014-03-26 19:17:54 | Re: Disk Encryption in Production |