TIPS

= Show Table Distribution and Replication

The following statement shows each table's distribution/replication status.

 SELECT pg_class.relname, pgxc_class.pclocatortype,pgxc_class.pcattnum FROM
        pg_class, pgxc_class WHERE pg_class.oid = pgxc_class.pcrelid;