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.:>