Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =# \d+ metabib.browse_entry
- Table "metabib.browse_entry"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
- --------------+----------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
- id | bigint | | not null | nextval('metabib.browse_entry_id_seq'::regclass) | plain | |
- value | text | | | | extended | |
- index_vector | tsvector | | | | extended | |
- sort_value | text | | not null | | extended | |
- Indexes:
- "browse_entry_pkey" PRIMARY KEY, btree (id)
- "browse_entry_sort_value_value_key" UNIQUE CONSTRAINT, btree (sort_value, value)
- "browse_entry_sort_value_idx" btree (sort_value)
- "metabib_browse_entry_index_vector_idx" gin (index_vector)
- Referenced by:
- TABLE "metabib.browse_entry_def_map" CONSTRAINT "browse_entry_def_map_entry_fkey" FOREIGN KEY (entry) REFERENCES metabib.browse_entry(id)
- TABLE "metabib.browse_entry_simple_heading_map" CONSTRAINT "browse_entry_simple_heading_map_entry_fkey" FOREIGN KEY (entry) REFERENCES metabib.browse_entry(id)
- Triggers:
- metabib_browse_entry_fti_trigger BEFORE INSERT OR UPDATE ON metabib.browse_entry FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('keyword')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement