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

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?

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

[SQL] how to show table structure?

Greetings, How can I see the layout of a table in PostgreSQL 7.4? I've checked several books and on-line documents, but was not able to figure out how PostgreSQL does 'describe ' like it's done in other databases. Thanks in advance for any help. Bing ---(end of broadcas