create table companies ( id integer not null primary key default nextval('public.documents_id_seq'::text), class text not null, ctime timestamp not null default now(), mtime timestamp not null default now(), dtime timestamp not null default now(), status smallint not null default 0, sections integer[], country text, city text, name text, service integer, rate integer, data text ); create index companies_sections on companies using gist ( "sections" "gist__int_ops" ); create index companies_city on companies ("city");