- 博客(2)
- 资源 (1)
- 收藏
- 关注
RSS订阅原创 Postgresql 添加分区表(按月和按日通用)
建了分区表的同学相信添加分区表很头疼，如果有按月分区又有按日分区的，而且是通过"_yyyymmdd"或者"_yyyymm"后缀进行分区的，那么可以用这个函数进行添加分区CREATE OR REPLACE FUNCTION f_add_partition()RETURNS voidLANGUAGE plpgsqlAS $function$declarev_
2016-05-06 16:51:59
12616
1
原创 Postgresql 远程同步(非实时同步，小数据量)
源端要开通目标的相关访问权限目标端：1.建立远程表的视图create view v_bill_tbl_version_update_control_info as SELECT * FROM dblink('hostaddr=10.10.10.8 port=4321 dbname=postgres user=postgres password=postgres', 'SEL
2016-05-06 10:31:25
4330
GREENPLUM管理向导
This guide provides information and instructions for configuring, maintaining and using a Greenplum Database system. This guide is intended for system and database administrators responsible for managing a Greenplum Database system.
This guide assumes knowledge of Linux/UNIX system administration, database management systems, database administration, and structured query language (SQL).
Because Greenplum Database is based on PostgreSQL 8.2.14, this guide assumes some familiarity with PostgreSQL. Links and cross-references to PostgreSQL documentation are provided throughout this guide for features that are similar to those in Greenplum Database.
2018-04-28
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人