I am trying to get my output of a "timestamp" feild to look like "Wed Dec 17
07:37:16 1997 PST"
I have tried from a psql prompt the following:
cprn_apl=> SET DATESTYLE TO 'Postgres';
cprn_apl=> select event_date from events;
But as you can see, output is still set to 'ISO'.
****I have also added the following line in my /etc/profile
I logged out and back in. At the linux prompt I can type 'set' and I can
see the 'PGDATESTYLE=Postgres' enviroment variable set. But starting up
psql and doing the same select statement above gives me the same ISO output.
I don't even really want the output within psql to be Postgres, I really
just want it to be for the output for my web based application using Pg in
Perl. I don't really know how to set variables for postgres (like
PGDATESTYLE) when there is no shell being invoked. Once I can get atleast
psql to output what I want how can I get a output set for a web invoked
perl/cgi program or is that also simply set in the /etc/profile file as
Thanks in advance
pgsql-interfaces by date
|Next:||From: Ed Loehr||Date: 2000-02-26 04:48:26|
|Subject: Re: [INTERFACES] Pgaccess - missing file, can't start|
|Previous:||From: Don Oliver||Date: 2000-02-25 19:19:46|
|Subject: Pgaccess - missing file, can't start|