On Sun, 3 Nov 2002, 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.
Have you tried setting the dutch locale on the account you use when restoring? And checked for localisation options in PostgreSQL configuration? - Jonas -- Jonas Smedegaard (+45 40843136) http://dr.jones.dk/~jonas/ Spiff ApS (= IT-guide dr. Jones ApS) http://dr.jones.dk/ Debian GNU/Linux developer http://people.debian.org/~js/
