PostgreSQL: Partitioning
Be aware that COPY ignores rules. If you want to use COPY to insert data, you’ll need to copy into the correct partition table rather than into the master. COPY does fire triggers, so you can use it normally if you use the trigger approach will fail because of the CHECK constraints. ...
PostgreSQL: Money与lc_monetary
[postgres:7440@mutou] [01-08.16:36:29]=# set lc_monetary='zh_CN';SET时间:39.176 ms[postgres:7440@mutou] [01-08.16:37:34]=# show lc_monetary; lc_monetary ------------- zh_CN(1 行记录)时间:0.319 ms[postgres:7440@mutou] [01-08.16:37:36]=# SELECT 12....
PostgreSQL的information_schema
PostgreSQL的information_schema
max_connections参数不一致导致备库应用日志失败
max_connections参数不一致导致备库应用日志失败
Postgresql的字符串日期类型转换
Postgresql的字符串日期类型转换
Postgresql中 ECHO_HIDDEN 参数的作用
Postgresql中 ECHO_HIDDEN 参数可显示"\"开头的命令执行的实际SQL