Author: Dan
Date: 21-01-05 00:58
In PostgreSQL, you can set the statistics for a given column with this statement:
alter table ports alter category_id set statistics 1000;
But how do you view the current settings?
select attrelid, attname, atttypid, attstattarget from pg_attribute where attrelid = (select oid from pg_class where relname = 'ports');
cheers
--
Webmaster
|
|