Search Postgresql Archives

Re: psql's "\d" and CLUSTER

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Igor Shevchenko wrote:
> Hi,
> 
> Are there any plans on adding CLUSTER-related information to "\d tablename" ?

This will be in the 7.5 release:

	test=> create table test (x int);
	CREATE TABLE
	test=> create index i on test(x);
	CREATE INDEX
	test=> cluster i on test;
	CLUSTER
	test=> \d test
	     Table "public.test"
	 Column |  Type   | Modifiers
	--------+---------+-----------
	 x      | integer |
	Indexes:
	    "i" btree (x) CLUSTER
	
	test=> \d i
	 Index "public.i"
	 Column |  Type
	--------+---------
	 x      | integer
	btree, for table "public.test", CLUSTER

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux