Julie Nishimura <juliezain@xxxxxxxxxxx> 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
