RES: set DateStyle to 'SQL'

Elielson Fontanezi <elielsonf@prodam.sp.gov.br>

From: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
To: Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Cc: pgsql-general <pgsql-general@postgresql.org>, pgsql-sql <pgsql-sql@postgresql.org>
Date: 2002-07-26T16:56:16Z
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@prodam.sp.gov.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.:>