sql语句小知识点随笔

最新推荐文章于 2024-04-24 18:27:59 发布

凡人·没有梦

最新推荐文章于 2024-04-24 18:27:59 发布

阅读量498

点赞数

分类专栏： sql 文章标签： sql

本文链接：https://blog.csdn.net/pleasurehappy/article/details/43700515

版权

sql 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

平时会经常遇到一些sql语句小技巧处理，每次遇到都查询互联网，从今天起自己总结：（本文章持续更新！）

字符串替换 REPLACE ( original-string, search-string, replace-string )

例子：select replace('hello world , how are you' , 'are' , 'old are'); 结果 ‘hello world , how old are you’ ;

postgresql ：使用sql语句查看数据表结构：

SELECT
 attrelid , attname  , description
     FROM
           pg_attribute
           INNER JOIN pg_class  ON pg_attribute.attrelid = pg_class.oid
           INNER JOIN pg_type   ON pg_attribute.atttypid = pg_type.oid
           LEFT OUTER JOIN pg_attrdef ON pg_attrdef.adrelid = pg_class.oid AND pg_attrdef.adnum = pg_attribute.attnum
           LEFT OUTER JOIN pg_description ON pg_description.objoid = pg_class.oid AND pg_description.objsubid = pg_attribute.attnum
     WHERE
           pg_attribute.attnum > 0
          AND attisdropped <> 't'
           AND pg_class.relname= 't_caroper_info_sync'  --t_caroper_info_sync为表名
     ORDER BY pg_attribute.attnum ;