只查某个dn的数据
最近更新时间: 2025-02-18 16:02:00
postgres=# create table t_direct(id int,mc text);
CREATE TABLE
postgres=# insert into t_direct values(1,'TDSQL PG'),(3,'pgxz');
INSERT 0 2
postgres=# EXECUTE DIRECT ON (dn001) 'select * from t_direct';
id | mc
----+-------
1 | TDSQL PG
(1 row)
postgres=# EXECUTE DIRECT ON (dn002) 'select * from t_direct';
id | mc
----+------
3 | pgxz
(1 row)
postgres=# select * from t_direct ;
id | mc
----+-------
1 | TDSQL PG
3 | pgxz
(2 rows)