RES: set DateStyle to 'SQL'
От | Elielson Fontanezi |
---|---|
Тема | RES: set DateStyle to 'SQL' |
Дата | |
Msg-id | A799F7647794D311924A005004ACEA97080DDEC2@cprodamibs249.prodam обсуждение исходный текст |
Список | pgsql-general |
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.:>
В списке pgsql-general по дате отправления: