Shulou(Shulou.com)06/01 Report--

1. View the greenplum distribution key

Select d.nspname | |'. | | a.relname as table_name,string_agg (b.attname1) as column_name

From

Pg_catalog.pg_class a

Inner join

Pg_catalog.pg_attribute b

On a.oid=b.attrelid

Inner join

Pg_catalog.gp_distribution_policy c

On a.oid=c.localoid

Inner join pg_catalog.pg_namespace d

On a.relnamespace=d.oid

Where a. Relkindson and b.attnum=any (c.attrnums)

And a.relname not like'% prt%'

Group by table_name

Order by table_name desc

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.