- 博客(3)
- 资源 (16)
- 问答 (1)
- 收藏
- 关注
原创 postgres store the dropped columns in pg_attribute
in postgres when we dropped colunms, in pg_attribute we still could see such as … pg.dropped.4…, therefore when you use pg_atrribute would like to select all the colunms of the table, you need to cons...
2019-12-28 01:46:44 628 1
原创 How to output the string which include %
how to output the string which include % Postgres complain synax error when error string include % IF ((NEW.percentage/power(10, NEW.decimals)) > 100) THEN RAISE EXCEPTION '100001, T...
2019-12-02 04:31:11 639
原创 How to non interactively provide password for the PostgreSQL interactive terminal
How to non interactively provide password for the PostgreSQL interactive terminal 在使用psql的时候,我们发现每次都要求用户输入密码,那如何非交互式地为PostgreSQL交互式终端提供密码呢?这里有两种方法: password file you can create .pgpass in your home d...
2019-12-02 04:04:17 250
怎样在procedure里写log日志
2014-12-02
TA创建的收藏夹 TA关注的收藏夹
TA关注的人