From 18ef42f5a89babf01bdce096d05fbb6471763f68 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 07 四月 2023 09:54:16 +0800
Subject: [PATCH] 1
---
data/db_cx.sql | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/data/db_cx.sql b/data/db_cx.sql
index 2fa9c30..ea60882 100644
--- a/data/db_cx.sql
+++ b/data/db_cx.sql
@@ -25,6 +25,30 @@
select * from lf.sys_download order by id desc limit 20; --downid
select * from lf.sys_apply order by id desc;
+select case a.userid when 2 then guid else null end "guid", a.* from lf.sys_apply a order by id desc
+
+select c.relname "tab", cast(obj_description(c.oid) as varchar) "desc", a.attnum "num",
+a.attname "col", t.typname "type", d.description "bak" from pg_attribute a left join pg_description d
+on d.objoid = a.attrelid and d.objsubid = a.attnum left join pg_class c on a.attrelid = c.oid left join pg_type t
+on a.atttypid = t.oid where a.attnum >= 0 and reltype>0 and relnamespace in (5424908) and c.relname='pl_pipelinepoint_f' and position('pg.dropped' in a.attname) = 0
+order by c.relname desc, a.attnum asc
+
+select * from bs.s_explorationpointstratum where exppointid in ('HJXK20')
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
--
Gitblit v1.9.3