Postgre Sql
大道泛兮
不要让青春在安逸中慢慢死去。
展开
-
PGSQL 使用mysql_fdw连接MySQL外库
CREATE SERVER "mysql_nash_invoice" FOREIGN DATA WRAPPER "mysql_fdw" OPTIONS (host '172.20.10.23', port '3306');ALTER SERVER "mysql_nash_invoice" OWNER TO "shujupingtai";CREATE USER M原创 2018-06-25 10:53:52 · 975 阅读 · 0 评论 -
Postgre Sql 写入Json字段数据
update nash_invoice set invoice_express='{"express_type":"","express_status":"","express_number":""}'; // 更新json字段数据delete from nash_invoice; //原创 2018-06-19 14:26:56 · 2901 阅读 · 2 评论 -
Postgre SQL 中Json字段新增数据
select json字段名::jsonb || ‘新增字段JSon格式’::jsonb from 表名;例:select invoice_base_info::jsonb || '{"info":"male"}'::jsonb from nash_invoice;来源:http://francs3.blog.163.com/blog/static/4057672720157153719...原创 2018-06-19 14:32:09 · 3513 阅读 · 1 评论 -
一段不知所云的SQL
delete from nash_invoice;INSERT INTO nash_invoice( id, invoice_no, contract_no, contract_type, customer_name, nash_company, opening_type, invoice_type, invoice_bas...原创 2018-08-01 10:34:47 · 224 阅读 · 0 评论