Julie Nishimura <juliez...@hotmail.com> writes: > Thank you. Is there a way to find out if I have tables with tsvectors or > indexes? I have hundreds of tables...
Search the system catalogs. I'd probably do it like this:
select attrelid::regclass, attname from pg_attribute
where atttypid = 'tsvector'::regtype;
but you could also devise some more-portable query involving
the information_schema ...
regards, tom lane
