researcher@Safe-mail.net wrote:
> Hello,
>
> I have upgraded to PostgreSQL 8.2.1 and to pgAdmin3 1.6.2. However, I
> cannot open the postgresql.conf file because it is located in
> /usr/local/pgsql/data/postgresql.conf with PgAdmin3.
Because the finder etc. hide /usr? Hmmm...
> How can I change
> the config? For example, I would like to set datestyle to 'European,
> German'.
IF you have the adminpack contrib module installed, you can edit the
config through the server rather than through the local filesystem.
> Interesting is, that when logged in to the terminal window as
> postgres user, I get the setting as European, German but when looking
> at the date rows in PgAdmin, it is the conventional US format. Hm,
> what is wrong? What should I do?
pgAdmin always displays dates in ISO 8601 format.
Regards, Dave.