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 to show existing query buffer contents but I don't know if
pgadmin has such a facility).
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services