Re: [SQL] can insert 'null' into timestamp type field from command

2004-01-13 Thread scott.marlowe
On Tue, 13 Jan 2004, Bing Du wrote: > The table is like this: > > > maxware=# \d test; >Table "public.test" > Column |Type | Modifiers > +-+--- > a | timestamp without time zone | > b | integ

Re: [SQL] can insert 'null' into timestamp type field from command

2004-01-13 Thread Bing Du
I've figured it out, that is using 'null as ' with the COPY command. Bing > The table is like this: > > > maxware=# \d test; >Table "public.test" > Column |Type | Modifiers > +-+--- > a | timestamp

[SQL] can insert 'null' into timestamp type field from command line but not from input file?

2004-01-13 Thread Bing Du
The table is like this: maxware=# \d test; Table "public.test" Column |Type | Modifiers +-+--- a | timestamp without time zone | b | integer | = The following inser