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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
