Re: [PERFORM] Showing Column Statistics Number

2006-01-11 Thread Michael Fuhr 
On Wed, Jan 11, 2006 at 04:05:18PM -0600, Dave Dutcher wrote:
> I've looked around through the docs, but can't seem to find an answer to
> this.  If I change a column's statistics with "Alter table alter column
> set statistics n", is there a way I can later go back and see what the
> number is for that column?  I want to be able to tell which columns I've
> changed the statistics on, and which ones I haven't.

pg_attribute.attstattarget

http://www.postgresql.org/docs/8.1/interactive/catalog-pg-attribute.html

-- 
Michael Fuhr

---(end of broadcast)---
TIP 4: Have you searched our list archives?

   http://archives.postgresql.org

[PERFORM] Showing Column Statistics Number

2006-01-11 Thread Dave Dutcher 








Hi,

 

I’ve looked around through the docs, but can’t
seem to find an answer to this.  If
I change a column’s statistics with “Alter table alter column set
statistics n”, is there a way I can later go back and see what the number
is for that column?  I want to be
able to tell which columns I’ve changed the statistics on, and which ones
I haven’t.

 

Thanks,

 

Dave