pgsql
一码平川
把coding作为一生的事业去努力
展开
-
【sql速查手册】postgresql between
sql postgresql between。原创 2022-08-11 11:13:28 · 1321 阅读 · 1 评论 -
PostgreSQL 字符串操作函数[转]
函数:string || string 说明:String concatenation字符串连接操作例子:'Post' || 'greSQL' = PostgreSQL函数:string || non-string or non-string ||string说明:String concatenation with one non-string input字符串与非字符串类型进行连接原创 2014-01-21 18:32:55 · 2669 阅读 · 0 评论 -
pgsql备忘录
长时间不用,命令都忘了,悲剧ing....1、\copy "hotel_manu_list"("name","hotel") from '/home/user/hotel_manu_list_utf8.csv' DELIMITERS',' CSV;备注:文件要用utf-8格式附:conv -f gbk -t utf-8 hotel_manu_list.csv-o hotel_manu原创 2014-01-21 18:33:07 · 573 阅读 · 0 评论 -
当postgresql表中主键自增出现问题…
SELECT MAX(id) FROM your_table;// Then run...// This should be higher than the last result.SELECT nextval('your_table_id_seq');// If it's not higher... run this to try and fix it. (run a quick pg_du原创 2014-01-21 18:33:16 · 2787 阅读 · 0 评论