substring(pg_catalogpg_getexpr(d.adbin, d.adrelid) for 128) FROM _catalog.pg_ d WHERE d.adrelid = a.attrelid ANDd.adnum = a.attnum ANDa.atthasdef, a.attnotnull a.attnum, a.attstorage, pg_catalogcol_descriptiona.attrelid, a.attnum) FROM pgcatalog.pg_...
SELECT * FROM 表名 WHERE 字段 LIKE ('%关键字%'); substring字符串截取 --从第一个位置开始截取,截取4个字符,返回结果:Post SELECT SUBSTRING ('PostgreSQL', 1, 4); -- 从第8个位置开始截取,截取到最后一个字符,返回结果:SQL SELECT SUBSTRING ('PostgreSQL', 8); --正则表达式截取,截取'gre'字符串...
c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' WHEN 'I' THEN 'pa...
c.relname as "Name", CASE c.relkind WHEN 'r' THEN 'table' WHEN 'v' THEN 'view' WHEN 'm' THEN 'materialized view' WHEN 'i' THEN 'index' WHEN 'S' THEN 'sequence' WHEN 's' THEN 'special' WHEN 'f' THEN 'foreign table' WHEN 'p' THEN 'partitioned table' WHEN 'I' THEN 'pa...