setting PGDATESTYLE

Stephan Richter <srichter@cbu.edu> writes:

So here my question: Is there any other way of globally changing the
DATESTYLE to SQL (at compile time or DB creation time)?

You can set it via an environment variable in the postmaster's
environment. See the docs.

It ought to be settable via postgresql.conf, but currently isn't.

regards, tom lane

Hi Tom.

I basically set it as environment variable now...

It ought to be settable via postgresql.conf, but currently isn't.

Yeah, that would be the right place. This way I only have to provide this
one file...even can make it part of the installation process...

Regards,
Stephan

--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management

On Tue, Jun 05, 2001 at 06:25:59PM -0400, Tom Lane wrote:

Stephan Richter <srichter@cbu.edu> writes:
So here my question: Is there any other way of globally changing the
DATESTYLE to SQL (at compile time or DB creation time)?

You can set it via an environment variable in the postmaster's
environment. See the docs.

It ought to be settable via postgresql.conf, but currently isn't.

Is there any file called postgresql.conf ? Where is it ?
The default installation does not create any such file.

Sorry for this silly question.

Warm Regards

--
Rajesh Fowkar
V. S. DEMPO & CO. LTD., PANAJI-GOA

Email ID : Mail@dempos.com, rfowkar@yahoo.com
Web Site : http://www.dempos.com

What version of PostgreSQL are you running? I think
the postgresql.conf file is pretty new (7.1.1?).

Andrew

--- Penguin <Mail@dempos.com> wrote:

On Tue, Jun 05, 2001 at 06:25:59PM -0400, Tom Lane
wrote:

Stephan Richter <srichter@cbu.edu> writes:
So here my question: Is there any other way of

globally changing the

DATESTYLE to SQL (at compile time or DB creation

time)?

You can set it via an environment variable in the

postmaster's

environment. See the docs.

It ought to be settable via postgresql.conf, but

currently isn't.

Is there any file called postgresql.conf ? Where is
it ?
The default installation does not create any such
file.

Sorry for this silly question.

Warm Regards

--
Rajesh Fowkar
V. S. DEMPO & CO. LTD., PANAJI-GOA

Email ID : Mail@dempos.com, rfowkar@yahoo.com
Web Site : http://www.dempos.com

---------------------------(end of
broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please
send an appropriate
subscribe-nomail command to majordomo@postgresql.org
so that your
message can get through to the mailing list cleanly

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/

On Fri, Jun 08, 2001 at 02:10:40PM +0530, Penguin wrote:

On Tue, Jun 05, 2001 at 06:25:59PM -0400, Tom Lane wrote:

Stephan Richter <srichter@cbu.edu> writes:
So here my question: Is there any other way of globally changing the
DATESTYLE to SQL (at compile time or DB creation time)?

You can set it via an environment variable in the postmaster's
environment. See the docs.

It ought to be settable via postgresql.conf, but currently isn't.

Is there any file called postgresql.conf ? Where is it ?
The default installation does not create any such file.

Sorry for this silly question.

not so silly, if you ask me. on my v7.0.3 setup (i use debian
2.2/potato) my /etc/postgresql dir looks like

% ls /etc/postgresql
pg_geqo
pg_hba.conf
pg_ident.conf
pg_options
postgresql.env
postmaster.init
postmaster.opts.default

so maybe they're referring to pg_hba.conf -- or, it may be part
of the source file set whereby compile-time options are set.
just guessing, of course; i could be wrong on both counts.

--
I figure: if a man's gonna gamble, may as well do it
without plowing. -- Bama Dillert, "Some Came Running"

will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!