![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
--------PostgreSQL
EchoShelter
怕什么真理无穷,进一寸有一寸的欢喜!
展开
-
Ubuntu17.04安装postgre 9.04
安装前检查检查是否安装了旧版本的postgre:dpkg -l | grep postgresql如果已经安装,需要先进行卸载。安装postgresql添加postgre源sudo touch /etc/apt/sources.list.d/pgdb.listsudo vim /etc/apt/sources.list.d/pgdb.list将下面的代码复...转载 2017-10-28 22:12:27 · 384 阅读 · 0 评论 -
postgre实现类似Oracle的trunc日期函数
原文地址:http://chnjone.blog.51cto.com/4311366/1658843create or replace function trunc(p_timestamp timestamp with time zone, p_formart varchar default 'DD') returns timestamp without time zone as$$...转载 2017-10-22 22:22:16 · 3085 阅读 · 0 评论