On maandag, nov 4, 2002, at 00:07 Europe/Amsterdam, Jonas Smedegaard wrote:
> > 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 The account is set to the Dutch locale, but nevertheless.... I'll try to set localization for PostgreSQL, but first have to find out how. All new to me. Thanks for the tip Jonas, Rik
