How should I go about importing the contents of an Excel spreadsheet into a Postgres database table?
I was considering a comma separated file, but am not sure how to import this into the database.
Are there any other suggestions?
Thanks Andrew
I have a timestamp field, into which I will be inserting UK style dates
i.e. 31/3/2000.
If I insert an ambiguous date i.e. 11/1/2000 postgresql seems to assume
that it is in US format.
How can I specify that the date will always be in UK format?
Andrew Mason
