I'm using Australian EST, but the database seems to use USA's EST. Therefore when I try to restore backup data, the time value of datetime field is incorrect. I know that the db can be recompiled to use australian option, but I don't want to risk db not compiling correctly. So, is it possible to dump the date time value without the timezone information or in 'yyyy/mm/dd hh:mm:ss+10' format which will restore the time value correctly?
I've written a VB application with connects to the database via ODBC. I've noticed that if I run the 'copy' command from the application, the date time value is something like 'yyyy/mm/dd hh:mm:ss+10' instead of 'yyyy/mm/dd hh:mm:ss EST' when I run the 'copy' command directly in psql. Any idea why this is so? I didn't specify any special option in ODBC connection. or there's something done I'm unaware of?