Tag Info

New answers tagged


Since 9.3, you can do this using \gset in psqlrc: select split_part(version(),' ',2) pmt \gset \set PROMPT1 '%:pmt:' Or, as 'the value of the selected prompt variable is printed literally, except where a percent sign (%) is encountered': select split_part(version(),' ',2) "PROMPT1" \gset If your version is <9.3, it's still possible, but much uglier, ...


Did you try to set the environment variable TNS_ADMIN to the directory in which you have your sqlnet.ora file?

Top 50 recent answers are included