Zhong Weicheng Study Notes

command linetestdb=> \dt List of relations Schema | Name | Type | Owner --------+-----------+-------+------- public | orderinfo | table | zwc(1 row)testdb=> testdb=> \d orderin

JDBC is the driver used to access a database with Java. Greenplum has a full working JDBC implementation.In this short article we’ll see how to use it.## Download and installIt is possible t

Oracle端表结构SQL> select dbms_metadata.get_ddl('TABLE','TAB_ORA','ZWC') from dual; CREATE TABLE "ZWC"."TAB_ORA" ( "ID" NUMBER, "OWNER" VARCHAR2(30), "NAME" VARCHAR2(128),

clusterdb clusterdb 对一个数据库中先前已经建过簇的表进行建簇. 使用方法: clusterdb [选项]... [数据库名] 选项:  -a,--all                 对所有数据库建簇  -d,--dbname=DBNAME       对数据库 DBNAME 建簇  -e,--echo                显示发

Installing and setting up Oracle GoldenGate connecting to an Oracle databaseAlso please make sure the Oracle database is in archive log mode[oracle@ggos ~]$ sqlplus / as sysdbaSQL*Plus: Releas

Master server configurationEdit postgresql.confAdd variablesarchive_mode = onarchive_command = 'cp "%p" /data/pgsql/data/pg_xlog/archive_status/"%f"'archive_timeout = 500wal_level = 'ho

Installation possible dependenciesyum -y install gcc gcc-c++ autoconf libjpeg libjpeg-devel libpng libpng-devel freetype freetype-devel libxml2 libxml2-devel zlib zlib-devel glibc glibc-devel glib

使用createuser来创建用户[postgres@web1 ~]$ /data/pgsql/bin/createuser --helpcreateuser creates a new PostgreSQL role.Usage: createuser [OPTION]... [ROLENAME]Options: -c, --connection-limit=N co

[postgres@zwc pg_xlog]$ psql -h 192.168.1.13 -p 1521 -U zwc -d testdbPassword for user zwc: psql (9.2.4)Type "help" for help.testdb=> select pg_current_xlog_location(); pg_current_xlog_location

database tablespace[postgres@zwc base]$ ls -ltotal 28drwx------ 2 postgres postgres 12288 Sep  2 10:13 1drwx------ 2 postgres postgres  4096 Aug 28 12:56 12783drwx------ 2 postgres postgres

表大小zwcdb=# select pg_size_pretty(pg_relation_size('gp_test')); pg_size_pretty ---------------- 1761 MB(1 row)表和索引zwcdb=# select pg_size_pretty(pg_total_relation_size('gp_test')); pg_size_pr