实验表结构及数据
最近更新时间: 2025-10-11 18:10:00
postgres=# \d+ t
Table "public.t"
Column | Type | Modifiers | Storage | Stats target | Description
--------+-----------------------------+---------------+----------+--------------+-------------
f1 | integer | not null | plain | |
f2 | character varying(32) | not null | extended | |
f3 | timestamp without time zone | default now() | plain | |
f4 | integer | | plain | |
Has OIDs: yes
Distribute By SHARD(f1)
Location Nodes: ALL DATANODES
#数据测试过程可以行再录入修改
postgres=# select * from t;
f1 | f2 | f3 | f4
----+-------+----------------------------+----
3 | pgxz | 2017-10-28 18:24:05.645691 |
1 | TDSQL PG | | 7
2 | | 2017-10-28 18:24:05.643102 | 3
(3 rows)