目录 1、Greenplum 基本查询信息 1.1、Greenplum 常用查询 1.2、Greenplum 触发器,锁,类型等相关信息 1.3、Gre...
| / | bigint | bigint | bigint | int8div | divide pg_catalog...| / | bigint | integer | bigint | int84div | divide pg_catalog...| / | bigint | smallint | bigint | int82div | divide pg_catalog...| / | circle | point | circle | circle_div_pt | divide pg_catalog...| / | double precision | double precision | double precision | float8div | divide pg_catalog
| lo_close | integer | integer | func pg_catalog | lo_creat |...| func pg_catalog | lo_from_bytea | oid | oid, bytea | func pg_catalog...| func pg_catalog | lo_import | oid | text, oid | func pg_catalog...pg_catalog | lo_tell | integer | integer | func pg_catalog | lo_tell64...，还有2个函数没有遵循命名约定：lowrite和loread： pg_catalog | loread | bytea | integer, integer | func pg_catalog |
default", "day_of_week" varchar(10) COLLATE "pg_catalog"."...default", "day_of_month" varchar(10) COLLATE "pg_catalog"."...default", "res_attr2" varchar(40) COLLATE "pg_catalog"."...default", "res_attr3" varchar(40) COLLATE "pg_catalog"."...default", "res_attr4" varchar(40) COLLATE "pg_catalog"."
log_info" ( "id" varchar(64) COLLATE "pg_catalog"."...default", "res_param" text COLLATE "pg_catalog"."...log_error_info" ( "id" varchar(64) COLLATE "pg_catalog"."...default", "name" varchar(255) COLLATE "pg_catalog"."...default", "user_id" varchar(64) COLLATE "pg_catalog"."
default" NOT NULL, "label" varchar(50) COLLATE "pg_catalog"."...default", "teacher_job" varchar(30) COLLATE "pg_catalog"."...default", "tip" varchar(500) COLLATE "pg_catalog"."...default", "can_learn" varchar(500) COLLATE "pg_catalog"."...default", "duration" varchar(50) COLLATE "pg_catalog"."
| table | postgres | 40 kB | pg_catalog | pg_amop | table | postgres |...80 kB | pg_catalog | pg_amproc | table | postgres | 64 kB | pg_catalog...| table | postgres | 392 kB | pg_catalog | pg_auth_members | table | postgres |...| BASE TABLE test | pg_catalog | pg_roles | VIEW test...| pg_catalog | pg_shadow | VIEW 查看表中字段的情况 test=# SELECT
tb_zealer_series" USING btree ( "cp" "pg_catalog"."...default", "label" varchar(100) COLLATE "pg_catalog"."...tb_zealer_media" USING btree ( "post_id" "pg_catalog"."...int4_ops" ASC NULLS LAST, "post_id" "pg_catalog"."...int4_ops" ASC NULLS LAST, "create_time" "pg_catalog"."
注意到pg_catalog、public、information_schema三者都是有初始授权的，记录下赋值方法和位置。...------------------------------------------------- 99 | pg_toast | 10 | 11 | pg_catalog.../ public pg_namespace.dat里面插入pg_catalog的tuple，但没有权限信息： [ { oid => '11', oid_symbol => 'PG_CATALOG_NAMESPACE...', descr => 'system catalog schema', nspname => 'pg_catalog', nspacl => '_null_' }, { oid => '99'...ProcessUtilitySlow (pstate=0x283fd28, pstmt=0x2745998, queryString=0x2744c88 "GRANT USAGE ON SCHEMA pg_catalog
以下是部分 1 一般来说每种数据库中都有一个或几个系统的数据库，在PG中schemaname 以 pg_catalog开头都是系统表，通过系统表我们就可以了解的大部分数据库系统所做的事情 1 查看当前所有的表...FROM information_schema.tables WHERE table_type = 'BASE TABLE' AND table_schema NOT IN ('pg_catalog...trigger SELECT DISTINCT trigger_name FROM information_schema.triggers WHERE trigger_schema NOT IN ('pg_catalog...以及关于 trigger 详细的信息 SELECT * FROM information_schema.triggers WHERE trigger_schema NOT IN ('pg_catalog...查看系统中创建的函数 SELECT routine_name FROM information_schema.routines WHERE specific_schema NOT IN ('pg_catalog
olddb" ( "id" int4 NOT NULL, "relevance1" varchar(255) COLLATE "pg_catalog"."...default", "relevance2" varchar(255) COLLATE "pg_catalog"."...default", "new_field" varchar(255) COLLATE "pg_catalog"."...default", "relevance2" varchar(255) COLLATE "pg_catalog"."...default", "new_field" varchar(255) COLLATE "pg_catalog"."
.' || tablename from pg_tables WHERE schemaname 'pg_catalog' AND schemaname 'information_schema...其本质可以拆分为循环下面的这两个语句： -- 获取所有表 select schemaname || '.' || tablename from pg_tables WHERE schemaname 'pg_catalog...for tbl in psql -qAt -c "select schemaname || '.' || tablename from pg_tables WHERE schemaname 'pg_catalog
default", "cover" varchar(500) COLLATE "pg_catalog"."...default", "digest" varchar(200) COLLATE "pg_catalog"."...default", "source_url" varchar(800) COLLATE "pg_catalog"."...tb_article" USING btree ( "msg_id" "pg_catalog"."...tb_article_comment" USING btree ( "content_id" COLLATE "pg_catalog"."default" "pg_catalog"."
func1"() RETURNS "pg_catalog"."void" AS $BODY$ -- returns void,在保存的时候自动会变成"pg_catalog"."...func1"() RETURNS "pg_catalog"."...func1"() RETURNS "pg_catalog"."...loops"() RETURNS "pg_catalog"."...fun_etc"() RETURNS "pg_catalog"."
-----+-------------------------+-------------- public | table_1 | 100002000 public | table_2 | 1846 pg_catalog...| pg_database | 1827 pg_catalog | pg_user_mapping | 1821 pg_catalog | pg_largeobject | 1821 · 显示被冻结的数据库信息
| foreign-data wrapper for distfs access file_fdw | 1.0 | pg_catalog | foreign-data wrapper...for flat file access hdfs_fdw | 1.0 | pg_catalog | foreign-data wrapper for flat file access...| 1.0 | pg_catalog | Foreign Data Wrapper for accessing logging data mot_fdw | 1.0 |...pg_catalog | foreign-data wrapper for MOT access plpgsql | 1.0 | pg_catalog | PL/pgSQL...procedural language security_plugin | 1.0 | pg_catalog | provides security functionality (8 rows
test" ( "id" int4 NOT NULL DEFAULT nextval('tt_id_seq'::regclass), "name" varchar(255) COLLATE "pg_catalog
g_class CLS LEFT JOIN pg_namespace N ON ( N.oid = CLS.relnamespace ) WHERE nspname NOT IN ( 'pg_catalog...LEFT JOIN pg_namespace N ON ( N.oid = CLS.relnamespace ) WHERE nspname NOT IN ( 'pg_catalog...LEFT JOIN pg_namespace N ON ( N.oid = CLS.relnamespace ) WHERE nspname NOT IN ( 'pg_catalog
gpadmin information_schema | gpadmin pg_aoseg | gpadmin pg_bitmapindex | gpadmin pg_catalog...gpadmin information_schema | gpadmin pg_aoseg | gpadmin pg_bitmapindex | gpadmin pg_catalog...public, pg_catalog
而且是根据特定的字段进行分区； 数据库自动的会根据你分区的字段 将数据存放到不同的表里面 2 实现 1 将一个基础表变成分区表，只需要在建表语句上加 PARTITION BY RANGE ( "obs_time" "pg_catalog
领取专属 10元无门槛券
手把手带您无忧上云
云服务器
ICP备案
对象存储
即时通信 IM
实时音视频
