![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
PostgreSQL
ZhongWeicheng
这个作者很懒,什么都没留下…
展开
-
PostgreSQL View the table structure
command linetestdb=> \dt List of relations Schema | Name | Type | Owner --------+-----------+-------+------- public | orderinfo | table | zwc(1 row)testdb=> testdb=> \d orderin原创 2013-08-28 18:10:57 · 930 阅读 · 0 评论 -
JDBC访问GreenPlum
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原创 2013-12-05 22:55:26 · 5375 阅读 · 0 评论 -
Oracle数据迁移到GreenPlum
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),原创 2013-12-04 22:17:59 · 4415 阅读 · 1 评论 -
PostgreSQL 9.2.4 命令行帮助及SQL语句简要说明
clusterdb clusterdb 对一个数据库中先前已经建过簇的表进行建簇. 使用方法: clusterdb [选项]... [数据库名] 选项: -a,--all 对所有数据库建簇 -d,--dbname=DBNAME 对数据库 DBNAME 建簇 -e,--echo 显示发原创 2013-09-05 18:27:33 · 9361 阅读 · 0 评论 -
Oracle GoldenGate for Oracle 11g to PostgreSQL 9.2.4 Configuration
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原创 2013-09-04 22:50:27 · 4746 阅读 · 2 评论 -
Postgres 9.2 Replication Configuration on CentOS 5
Master server configurationEdit postgresql.confAdd variablesarchive_mode = onarchive_command = 'cp "%p" /data/pgsql/data/pg_xlog/archive_status/"%f"'archive_timeout = 500wal_level = 'ho原创 2013-09-03 22:09:09 · 1289 阅读 · 0 评论 -
Linux下源码编译安装PostgreSQL
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原创 2013-01-14 17:32:01 · 3190 阅读 · 0 评论 -
PostgreSQL创建用户,数据库,表
使用createuser来创建用户[postgres@web1 ~]$ /data/pgsql/bin/createuser --helpcreateuser creates a new PostgreSQL role.Usage: createuser [OPTION]... [ROLENAME]Options: -c, --connection-limit=N co原创 2013-01-18 11:14:34 · 19903 阅读 · 0 评论 -
PostgreSQL View current log
[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原创 2013-09-02 14:32:30 · 935 阅读 · 0 评论 -
PostgreSQL Use oid2name view the tables in the database
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原创 2013-09-02 13:55:38 · 1237 阅读 · 0 评论 -
GreenPlum查看表和数据库大小
表大小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原创 2013-12-27 13:28:43 · 13467 阅读 · 0 评论