On 03/11/2002 14:48 Rik Zandvoort wrote: > > I am using the Dutch templates and did set the user date format to > dd-mm-yy. Now, making a backup I get a backup file with the date-data > in format dd-mm-yy. > > Restoring this file with 'psql databasename < dataset-1.8.5.sql' > results in a working set in which the dateformat is mm-dd-yy instead of > dd-mm-yy. > > Does somebody know if I have to use a different psql command to get > this right? Now I have to make a second backup and restore a second > time to get the dd-mm-yy format again. > > thanks in advance, > > Rik >
I've had the same problem which seems to be that psql will assume a date is US (mm/dd/yy) format. To get round it, I save my backup file using pg_dump -c -d <dbname> The -d makes it generate the dump with dates in yyyy-mm-dd format which psql then processes correctly when restoring the database. Hope this helps. -- Paul Thomas Thomas Micro Systems Limited http://www.tmsl.demon.co.uk
