[ILUG-BOM] Date Output Setting in Postgres

Hi,

I am having problem setting the "Date" output settings. I am using Postgres 7.4.3. I have changed the datestyle setting in "postgresql.conf" as,

datestyle = 'SQL, DMY'

But still when I do a show all, I get

DateStyle ISO, DMY

Why is it stuck with "ISO", instead of "SQL". The reason I want "SQL" is that I want the date output format as dd/mm/yyyy instead of yyyy/mm/dd when I browse the records.

Another problem was that I could not set the datestyle with the SET command. So, I modified the postgresql.conf file. But still the problem is only partially solved as the datestyle still remains "ISO", instead of "SQL".

I am using phpPgAdmin as frontend.

Thanks, Rajen.