标签：body abc uuid -- 基础 pgsql key SELECT
https://www.cnblogs.com/chenyablog/p/14647273.html
--查看版本
SELECT version();
--创建uuid 扩展
create extension "uuid-ossp";
--生成一个uuid
SELECT uuid_generate_v4();
SELECT * from abc where body.key="22"
SELECT
info -> 'customer' AS customer
FROM
orders;
--查询json某个字段 作为键
select body -> 'key' as key from abc;
--查询json某个字段 作为文本(没引号)
select body ->> 'key' as key from abc;
SELECT name, body ->> 'key' key, body ->>'mtmNo' mtnNo from abc where body ->>
'key'='22'
pgsql:不区分utf8与utf8mb4支持表情符号：
标签：body,abc,uuid,--,基础,pgsql,key,SELECT
From： https://www.cnblogs.com/coderdxj/p/18099933