pg数据库表存放在哪里_在Greenplum数据库中,临时表存储在哪里?

Greenplum中的临时表存储在创建它们的数据库中,但存储在临时模式中,该模式在创建表的会话期间有效。

即

[gpadmin@mdw:~] $ createdb temp

[gpadmin@mdw:~] $ psql temp

temp=# create temporary table test_temp(a int) distributed by (a);

CREATE TABLE

Time: 50.516 ms

temp=# \d

List of relations

Schema | Name | Type | Owner | Storage

------------+-----------+-------+---------+---------

pg_temp_11 | test_temp | table | gpadmin | heap

(1 row)

temp=# \dn

List of schemas

Name | Owner

--------------------+---------

gp_toolkit | gpadmin

information_schema | gpadmin

pg_aoseg | gpadmin

pg_bitmapindex | gpadmin

pg_catalog | gpadmin

pg_temp_11 | gpadmin

pg_toast | gpadmin

pg_toast_temp_11 | gpadmin

public | gpadmin

(9 rows)

temp=#