Julie Nishimura <juliezain(at)hotmail(dot)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