Advertisement
chrissharp123

Untitled

Jul 19th, 2023
186
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.61 KB | None | 0 0
  1. =# \d+ metabib.browse_entry
  2. Table "metabib.browse_entry"
  3. Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
  4. --------------+----------+-----------+----------+--------------------------------------------------+----------+--------------+-------------
  5. id | bigint | | not null | nextval('metabib.browse_entry_id_seq'::regclass) | plain | |
  6. value | text | | | | extended | |
  7. index_vector | tsvector | | | | extended | |
  8. sort_value | text | | not null | | extended | |
  9. Indexes:
  10. "browse_entry_pkey" PRIMARY KEY, btree (id)
  11. "browse_entry_sort_value_value_key" UNIQUE CONSTRAINT, btree (sort_value, value)
  12. "browse_entry_sort_value_idx" btree (sort_value)
  13. "metabib_browse_entry_index_vector_idx" gin (index_vector)
  14. Referenced by:
  15. TABLE "metabib.browse_entry_def_map" CONSTRAINT "browse_entry_def_map_entry_fkey" FOREIGN KEY (entry) REFERENCES metabib.browse_entry(id)
  16. TABLE "metabib.browse_entry_simple_heading_map" CONSTRAINT "browse_entry_simple_heading_map_entry_fkey" FOREIGN KEY (entry) REFERENCES metabib.browse_entry(id)
  17. Triggers:
  18. metabib_browse_entry_fti_trigger BEFORE INSERT OR UPDATE ON metabib.browse_entry FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('keyword')
  19.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement