am Tue, dem 19.06.2007, um 13:12:58 +0530 mailte soni de folgendes: > Hello, > > We have installed postgres 8.2.0 > > default time zone which postgres server using is > > template1=# SHOW timezone; > TimeZone > ----------- > ETC/GMT-5 > (1 row) > > > But we want to set this timezone parameter to IST. > Our system timezone is also in IST. We are using solaris.
ALTER DATABASE foo SET TIMEZONE TO 'bla'; You can alter the template-database. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
