===========PostgreSQL==============数据库名SELECT datname FROM pg_database得到所有用户自定义表的名字select tablename from pg_tables where schemaname=public列名select COLUMN_NAME from information_schema.columns...

drop TABLE IF EXISTS temp_a;--创建临时表判断表是否存在CREATE TEMP TABLE IF NOT EXISTS temp_a(id varchar(100),resourcetype varchar(100),resourcetype_ varchar(100),fullurl varchar(300));...

数据库查询与程序查询 now() 时间不对 因为时区不一致更改数据库时区select now() at time zone 'Asia/Shanghai'ALTER DATABASE design SET timezone TO 'Asia/Shanghai'...

select '1234' ~ '^([0-9]+[.]?[0-9]*|[.][0-9]+)$'select '12344444' ~ '^([0-9]?[0-9]*|[0-9]+)$''^([0-9]?[0-9]+)$'

select schedule.*,cast(schedule.计划描述 as varchar) as 描述 ,job.名称 as 作业名称,CASE CAST( 执行方式 as VARCHAR )WHEN '0' then CAST('仅触发器触发' as VARCHAR )WHEN '1' then CAST('执行一次' as VARCHAR ) WHEN '2' then...

CREATE DATABASE database_name;SELECT u.datname FROM pg_catalog.pg_database u where u.datname='database_name';

https://www.cnblogs.com/ficow/p/6612484.html 当你要创建的表的表名是需要大写的，那你就用双引号""括起来；以后只要是和这个表有关的操作，都要用""把表名给括起来，注意是英文状态的双引号！...

select  *, position(' ddd' in cast(filedname as varchar)) as myfiledfrom mytable

在部署的系统安装 unigui把exe拷贝到服务器下就可以了可能会提示缺少MSVCR100.DLL请下载https://download.youkuaiyun.com/download/ozhy111/10741311

SELECT   tablename   FROM   pg_tables WHERE   tablename   NOT   LIKE   'pg%'AND tablename NOT LIKE 'sql_%'  ORDER   BY   tablename; 或select tablename from pg_tables where schemaname='public'...

alter user postgres with password '123';

https://blog.youkuaiyun.com/kmblack1/article/details/78398602 速度最快,9.4或更高版本首选这个函数 可以判断临时表 if( to_regclass('test') is null ) then 你的代码 end if; -----------------------------------------------------方...

 --创建枚举类型。CREATE TYPE mood AS ENUM ('sad', 'old_value', 'happy'); --创建表CREATE TABLE person (    name VARCHAR(20),    current_mood mood);--插入数据INSERT INTO person VALUES ('Moe', 'happy');--查...

------ postgresql扩展extension树ltree-----树的结构图                        Top                     /   |  \             Science Hobbies Collections                 /       |              \        Astro...

------postgresql扩展extension跨库查询dblink---------https://blog.youkuaiyun.com/luojinbai/article/details/45032683---在Mydb库创建表tb1create table tb1(id integer,nm varchar(20));---在另外库create extension dblink;...

 create TEMPORARY table tmp (ip varchar(20) ,users varchar(50));insert into tmp (ip,users) values('10.211.55.6','studio');--获取临时表名称select schemaname from pg_tables where tablename = 'tmp'//注意临时...

 create extension pgcrypto; 定义--encrypt(bytea, bytea, text)--text加密方式AESDES/3DES/CAST5Blowfish查询表时一定符合类型select nm, encrypt(cast(tb1.nm as bytea) ,'aa','aes') from tb1 select nm,test...