PostgreSQL
shoot_your_face
这个作者很懒,什么都没留下…
展开
-
PostgreSqlHelper类
public class PostgreSqlHelper { public string connectionString = null; public PostgreSqlHelper(string conn) { connectionString = conn; }原创 2015-07-24 11:09:11 · 1760 阅读 · 0 评论 -
PostgreSQL设置自增长从当前最大值开始
select setval('tablename_id_seq',(select max(id) from tablename))将tablename换成具体的表名即可原创 2015-07-21 11:53:01 · 5696 阅读 · 0 评论 -
PostgreSQL获取天数
select producename ||'注册证即将到期' as message,extract(DAY from (failuredate-NOW() )) from producetable原创 2015-07-21 11:18:57 · 4243 阅读 · 0 评论