Вот на такую последовательность команд:
/*
inventory_accno_id int,
income_accno_id int,
expense_accno_id int,
fxgain_accno_id int,
fxloss_accno_id int,
*/
\COPY defaults FROM stdin WITH DELIMITER |
sinumber|1
sonumber|1
yearend|1
businessnumber|1
version|1.2.0
closedto|\N
revtrans|1
ponumber|1
sqnumber|1
rfqnumber|1
audittrail|0
vinumber|1
employeenumber|1
partnumber|1
customernumber|1
vendornumber|1
glnumber|1
projectnumber|1
\.
-- */
ругается сначала так:
2011-04-20 18:31:31 MSD ERROR: syntax error at or near "|" at character 42
2011-04-20 18:31:31 MSD STATEMENT: COPY defaults FROM STDIN WITH DELIMITER |
а потом так:
2011-04-20 18:31:32 MSD ERROR: syntax error at or near "sinumber" at character 126
2011-04-20 18:31:32 MSD STATEMENT: /*
inventory_accno_id int,
income_accno_id int,
expense_accno_id int,
fxgain_accno_id int,
fxloss_accno_id int,
*/
sinumber|1
sonumber|1
yearend|1
businessnumber|1
version|1.2.0
closedto|
revtrans|1
ponumber|1
sqnumber|1
rfqnumber|1
audittrail|0
vinumber|1
employeenumber|1
partnumber|1
customernumber|1
vendornumber|1
glnumber|1
projectnumber|1
CREATE TABLE acc_trans (
trans_id int,
chart_id int NOT NULL REFERENCES chart (id),
amount NUMERIC,
transdate date DEFAULT current_date,
source text,
cleared bool DEFAULT 'f',
fx_transaction bool DEFAULT 'f',
project_id int,
memo text,
invoice_id int,
entry_id SERIAL PRIMARY KEY
);
Понятно что где-то синтакс. ошибка. Где?