![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
winner_corl
态度决定一切!
展开
-
pgsql 跨库查询例子
SELECT dblink.user_id, dblink.user_code, dblink.username, dblink.staff_name, dblink.telephone, dblink.staff_idFROM dblink('dbname=platform host=192.168.11.139 port=5444 user=platform password=platform'::text, .原创 2020-12-31 11:06:51 · 968 阅读 · 0 评论 -
PLSQL 季度函数写法/for循环动态sql执行
参考文章: 从PostgreSQL函数返回SETOF行 PL/pgSQL 的循环语句 PostgreSQL 遍历表的PLSQL列举 .最简单的例子CREATE OR REPLACE FUNCTION for_gen_demo1() RETURNS TABLE ( col1 varchar, col2 varchar ) language plpgsql AS$func$B原创 2020-12-29 16:48:31 · 1854 阅读 · 0 评论