RES: set DateStyle to 'SQL'

From: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
To: Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: RES: set DateStyle to 'SQL'
Date: 2002-07-26 16:56:16
Message-ID: A799F7647794D311924A005004ACEA97080DDEC2@cprodamibs249.prodam
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Friends, that is what the documents says:
---------------------------------------------------------------
1.6.2. Environment Variables
If you installed into /usr/local/pgsql or some other location that is not
searched for programs by default, you need to add /usr/local/pgsql/bin (or
whatever you set --bindir to in step 1) into your PATH. To do this, add the
following to your shell start-up file, such as ~/.bash_profile (or
/etc/profile, if you want it to affect every user):

PATH=/usr/local/pgsql/bin:$PATH
If you are using csh or tcsh, then use this command:

set path = ( /usr/local/pgsql/bin $path )

To enable your system to find the man documentation, you need to add a line
like the following to a shell start-up file:

MANPATH=/usr/local/pgsql/man:$MANPATH

The environment variables PGHOST and PGPORT specify to client applications
the host and port of the database server, overriding the compiled-in
defaults. If you are going to run client applications remotely then it is
convenient if every user that plans to use the database sets PGHOST. This is
not required, however: the settings can be communicated via command line
options to most client programs.
---------------------------------------------------------------

But... likely there are much more variables rather than PGDATA,
PGHOST and PGPORT.
Where can I find them?

E.F.:> -----Mensagem original-----
E.F.:> De: Elielson Fontanezi
E.F.:> Enviada em: sexta-feira, 26 de julho de 2002 11:42
E.F.:> Para: Elielson Fontanezi
E.F.:> Cc: pgsql-sql; pgsql-admin
E.F.:> Assunto: RES: [GENERAL] set DateStyle to 'SQL'
E.F.:>
E.F.:>
E.F.:> Hi friends!
E.F.:>
E.F.:> Maybe I have not been clear.
E.F.:> See, there are varibles like PGPORT, PG_HBA_SAMPLE,
E.F.:> POSTGRES_BKI,
E.F.:> POSTGRESQL_CONF_SAMPLE and much more.
E.F.:> Where ca I find related information to them? and list
E.F.:> of all them?
E.F.:>
E.F.:> my regards,
E.F.:>
E.F.:> E.F.:> -----Mensagem original-----
E.F.:> E.F.:> De: Elielson Fontanezi [mailto:ElielsonF(at)prodam(dot)sp(dot)gov(dot)br]
E.F.:> E.F.:> Enviada em: sexta-feira, 26 de julho de 2002 10:28
E.F.:> E.F.:> Para: pgsql-general
E.F.:> E.F.:> Cc: pgsql-sql
E.F.:> E.F.:> Assunto: [GENERAL] set DateStyle to 'SQL'
E.F.:> E.F.:>
E.F.:> E.F.:>
E.F.:> E.F.:> Hi folks!
E.F.:> E.F.:>
E.F.:> E.F.:> There are a buch of varibles like DateStyle. I am
E.F.:> E.F.:> interested to set
E.F.:> E.F.:> them
E.F.:> E.F.:> all in script shell.
E.F.:> E.F.:> I've tried in postgresql.conf, but I could not.
E.F.:> E.F.:> I've tried in shell environment, but it did not work.
E.F.:> E.F.:>
E.F.:> E.F.:> So, how can I do that?
E.F.:> E.F.:>
E.F.:>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Elielson Fontanezi 2002-07-26 17:09:29 Numeric Style format
Previous Message Masaru Sugawara 2002-07-26 16:36:02 Re: Oracle to PGSQL -- need help

Browse pgsql-sql by date

  From Date Subject
Next Message Elielson Fontanezi 2002-07-26 17:09:29 Numeric Style format
Previous Message Elielson Fontanezi 2002-07-26 14:42:04 RES: [GENERAL] set DateStyle to 'SQL'