CREATE TABLE foo (
    invno           integer                 not null,
    customer        character varying(10)   not null,
    account         character varying(8)    not null,
    invdate         date                    not null default ('now'::text)::date,
    taxpoint        date                    not null default ('now'::text)::date,
    discount        numeric(5,3)            not null default 0.0,
    ordno           integer                 not null,
    custref         text                    not null default 'NONE'::text,
    currency        character(3)            not null,
    carriage        numeric(10,2)           not null default 0.00,
    printed         boolean                 not null default false,
    assigned        boolean                 not null default false,
    customer_ean    character varying(13)  ,
    location_ean    character varying(13)  ,
    exchange_rate   numeric(10,4)          ,
    grpid           character varying(2)   ,
    postcode        character varying(10)  ,
    grn             character varying(20)  ,
    orderdate       date                   ,
    packages        integer                 not null default 1,
    packing         numeric(12,2)          ,
    other           numeric(12,2)          ,
    other_desc      text                   ,
    insurance       numeric(12,2)          ,
    pack_desc       text                   ,
    kilos           numeric(12,3)          ,
    nett            numeric(12,3)          ,
    dimensions      text                   ,
    terms           text                   ,
    bank            text                   ,
    goods           text                   ,
    marks           text                   ,
    port            text                   ,
    transport       text                   ,
    destination     character(2)           ,
    origin          character(2)            not null default 'GB'::bpchar,
    auth            text                   ,
    copies          integer                 not null default 1
);

COPY foo FROM stdin;
67829	22058	X378	10 FEB 2004	10 FEB 2004	0.000	5411	15498-00	GBP	0.00	t	t	\N	\N	\N	\N	\N	\N	10 FEB 2004	60	0.00	0.00	0	0.00	Carton	570.000	0.000		CIF-MONTREAL/ACT 30-DAYS		Chemist\'s sundries	AMG MEDICAL;5411;MONTREAL;1-60;	THAMESPORT	SEA/ALLIANCE	CA	GB	MAIREAD BOYCE, DIRECTOR	1
\.

SELECT * FROM foo;
