Postgresql (psql) .psqlrc技巧和窍门

发布时间：2020-12-13 17:50:53 所属栏目：百科来源：网络整理

导读：Set all null fields to NULL: pset null 'NULL' After this,the query results look like this: select 'test' as test_text,null as test_null; test_text | test_null-----------+----------- test| NULL(1 row) Set the command history file names for

Set all null fields to NULL:

pset null 'NULL'

After this,the query results look like this:

select 'test' as test_text,null as test_null;
 test_text | test_null
-----------+-----------
 test| NULL
(1 row)

Set the command history file names for each host and database:

set HISTFILE ~/.psql_history- :HOST - :DBNAME

After this,the history file naming look like this:

.psql_history-alpha-testdb
.psql_history-localhost-test
.psql_history-10.20.10.101-production
...

Set the number of commands to store in the command history:

set HISTSIZE 2000

Set timing on and see how long query took:

timing

psql prompt can be customized to your preference:

set PROMPT1 '(%n@%M:%>) [%/] > ' set PROMPT2 ''

After this,the PROMPT1 look like this:

(wwwuser@alpha:5432) [webdb] >

And PROMPT2 is empty.
Complete information can be found here,under prompting.

Set client encoding:

encoding unicode

Final .psqlrc file look like this:

'NULL' set HISTFILE ~/.psql_history- :HOST - :DBNAME set HISTSIZE 2000 timing set PROMPT1 '' encoding unicode

One additional tip is to add less to PAGER environment variable if you want to use less rather than more. So simply add following row to profile (/etc/profile or ~/.profile):

export PAGER=less

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!