fsstyle的专栏

postgresql10以下不支持不同实例的跨库表，可以通过psql客户端+系统定时任务实现类似功能。sql1="truncate table table_app"sql2="select wp.id as app_id, pv.id as version_id, pv.download as url, 'cc' as check_type from table_app"echo "$(date "+%Y%m%d %H:%M") Begin sync game data from prd db

有时候，我们需要构造一个自然天的列作为temp表来join其他表数据，列出当月(或某几月）所有日期：select to_char(tt.day, 'yyyy-mm-dd') as dayfrom (select generate_series(cast(to_char(current_date, 'yyyy-mm') || '-01' as date),cast(cast(to_ch...

批量更新： update package_android_today_download_countset cnt = tmp.cntfrom (values (1,2),(2,3),(3,4),(4,5),(5,6)) as tmp (package_id, cnt)where package_android_today_download_count.package_id = tmp...

postgres_fdw模块PostgreSQL 9.3 add postgres_fdw extension for accessing remote tables PostgreSQL 9.3新增了一个postgres_fdw模块, 已经整合在源码包中. 用于创建postgres外部表.注：db_des为目标库，developer_month_orders_data为表名。意思就是从...

1.查询激活的执行中的sql,查看有哪些更新update的sql。select *from pg_stat_activitywhere state = 'active';2. 查询表中存在的锁select a.locktype, a.database, a.pid, a.mode, a.relation, b.relnamefrom pg_locks ajoin pg...

SELECT extract(DOW FROM cast('2019-04-23 16:25' as TIMESTAMP));把DOW替换成DAY，可以获取是当月第几天。