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
\.
? – Jan Marek Feb 22 '12 at 12:19