We're in the process of switching hosts and our old host provided a SQL dump of the PostgreSQL database of our site. Now, we're looking to set it up on a local WAMP server to do some testing. But we're running into an issue with importing that database in the PostgreSQL 9 that we have set up. We've already tried "pgAdmin" but we can't find the import function. We opened it through SQL editor and put the content in there but it's coming back with errors when my team puts the data in.
ERROR: syntax error at or near "t"
LINE 474: t 2011-05-24 16:45:01.768633 2011-05-24 16:45:01.768633 view...
COPY tb_abilities (active, creation, modtime, id, lang, title, description) FROM stdin;
t 2011-05-24 16:45:01.768633 2011-05-24 16:45:01.768633 view nl ...
Anyone have an idea on what we should do here? Appreciate all help.