Обсуждение: Showing Column Statistics Number

Поиск
Список
Период
Сортировка

Showing Column Statistics Number

От
"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

Re: Showing Column Statistics Number

От
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