pgsql的UUID生成函数实例_PostgreSQL

pgsql的UUID生成函数实例

2021-03-23 21:13LordSnow_123 PostgreSQL

这篇文章主要介绍了pgsql的UUID生成函数实例，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧

– pgsql

– 安装函数

– UUID生成函数: pgsql默认安装是没有该类函数的,若脚本执行到此处出错,需打开下面注释,安装UUID生成函数

1	`create` `extension “uuid-ossp” ;`

– 使用函数

									select uuid_generate_v4();

									select replace(cast(uuid_generate_v4() as VARCHAR), ‘-', ‘');

									select translate(cast(uuid_generate_v4() as VARCHAR), ‘-', ‘');

									INSERT INTO mdc.base_org (

									uuid,

									NAME,

									org_parent_uuid,

									delete_flag,

									court_uuid,

									create_time,

									update_time,

									create_user,

									update_user,

									is_parent,

									sort_by,

									org_type

									)

									VALUES

									(

									(

									SELECT

									REPLACE (

									CAST (

									uuid_generate_v4 () AS VARCHAR

									),

									‘-',

									‘'

									)

									),

									‘测试小区',

									‘0',

									1,

									‘c69aeede4f6341929721e2892beec3cb',

									now(),

									now(),

									‘admin',

									‘admin',

									TRUE,

									‘001',

									‘1'

									);

补充：解决在postgressql中创建uuid函数失败问题

ERROR: could not access file "$libdir/uuid-ossp"

									<span style="font-family:Microsoft YaHei;">STATEMENT: CREATE FUNCTION uuid_generate_v4() RETURNS uuid

									   LANGUAGE c STRICT

									   AS '$libdir/uuid-ossp', 'uuid_generate_v4';</span>