I dumped my postgres db using pgAdmin in plain format because I wanted to search for some text on it. After doing the search, I decided to import the db back from the sql query window but I get this error
ERROR: syntax error at or near "330"
LINE 48882: 330 643 644 1 2012-01-11 16:04:20.468 2012-01-17 22:33:23.99...
This is the part that gives the error. I know I didn't modify anything here. It is what it dumped for me
COPY account_account (id, parent_left, parent_right, create_uid, create_date, write_date, write_uid, code, reconcile, currency_id, user_type, active, name, level, company_id, shortcut, note, parent_id, currency_mode, type) FROM stdin; 330 643 644 1 2012-01-11 16:04:20.468 2012-01-17 22:33:23.993 1 40300010 f \N 8 t Rent Income 5 1 \N \N 329 current other 55 89 94 1 2012-01-05 23:50:08.524 2012-01-10 12:32:51.934 1 12000000 f \N 18 t Long Term Investments 3 1 \N \N 24 current view
Here is the code that creates the table
CREATE TABLE account_account ( id integer NOT NULL, parent_left integer, parent_right integer, create_uid integer, create_date timestamp without time zone, write_date timestamp without time zone, write_uid integer, code character varying(64) NOT NULL, reconcile boolean, currency_id integer, user_type integer NOT NULL, active boolean, name character varying(128) NOT NULL, level integer, company_id integer NOT NULL, shortcut character varying(12), note text, parent_id integer, currency_mode character varying(16) NOT NULL, type character varying(16) NOT NULL );
I am so confused here. Please what could be the problem