Skip to content

Instantly share code, notes, and snippets.

@cleydyr
Last active December 10, 2022 23:50
Show Gist options
  • Save cleydyr/17632bb4ccffd879038c3bd5e126c449 to your computer and use it in GitHub Desktop.
Save cleydyr/17632bb4ccffd879038c3bd5e126c449 to your computer and use it in GitHub Desktop.
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM access_cards) t) TO '/tmp/access_cards.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM access_control) t) TO '/tmp/access_control.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_brief_formats) t) TO '/tmp/authorities_brief_formats.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_form_datafields) t) TO '/tmp/authorities_form_datafields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_form_subfields) t) TO '/tmp/authorities_form_subfields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_idx_autocomplete) t) TO '/tmp/authorities_idx_autocomplete.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_idx_fields) t) TO '/tmp/authorities_idx_fields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_idx_sort) t) TO '/tmp/authorities_idx_sort.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_indexing_groups) t) TO '/tmp/authorities_indexing_groups.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_records) t) TO '/tmp/authorities_records.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_search_results) t) TO '/tmp/authorities_search_results.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM authorities_searches) t) TO '/tmp/authorities_searches.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM backups) t) TO '/tmp/backups.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_brief_formats) t) TO '/tmp/biblio_brief_formats.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_form_datafields) t) TO '/tmp/biblio_form_datafields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_form_subfields) t) TO '/tmp/biblio_form_subfields.json';q
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_holdings) t) TO '/tmp/biblio_holdings.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_idx_autocomplete) t) TO '/tmp/biblio_idx_autocomplete.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_idx_fields) t) TO '/tmp/biblio_idx_fields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_idx_sort) t) TO '/tmp/biblio_idx_sort.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_indexing_groups) t) TO '/tmp/biblio_indexing_groups.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_records) t) TO '/tmp/biblio_records.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_search_results) t) TO '/tmp/biblio_search_results.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM biblio_searches) t) TO '/tmp/biblio_searches.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM configurations) t) TO '/tmp/configurations.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM digital_media) t) TO '/tmp/digital_media.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM holding_creation_counter) t) TO '/tmp/holding_creation_counter.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM holding_form_datafields) t) TO '/tmp/holding_form_datafields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM holding_form_subfields) t) TO '/tmp/holding_form_subfields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM lending_fines) t) TO '/tmp/lending_fines.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM lendings) t) TO '/tmp/lendings.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM logins) t) TO '/tmp/logins.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM orders) t) TO '/tmp/orders.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM permissions) t) TO '/tmp/permissions.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM quotations) t) TO '/tmp/quotations.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM request_quotation) t) TO '/tmp/request_quotation.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM requests) t) TO '/tmp/requests.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM reservations) t) TO '/tmp/reservations.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM suppliers) t) TO '/tmp/suppliers.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM translations) t) TO '/tmp/translations.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM users) t) TO '/tmp/users.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM users_fields) t) TO '/tmp/users_fields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM users_types) t) TO '/tmp/users_types.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM users_values) t) TO '/tmp/users_values.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM versions) t) TO '/tmp/versions.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_brief_formats) t) TO '/tmp/vocabulary_brief_formats.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_form_datafields) t) TO '/tmp/vocabulary_form_datafields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_form_subfields) t) TO '/tmp/vocabulary_form_subfields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_idx_autocomplete) t) TO '/tmp/vocabulary_idx_autocomplete.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_idx_fields) t) TO '/tmp/vocabulary_idx_fields.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_idx_sort) t) TO '/tmp/vocabulary_idx_sort.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_indexing_groups) t) TO '/tmp/vocabulary_indexing_groups.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_records) t) TO '/tmp/vocabulary_records.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_search_results) t) TO '/tmp/vocabulary_search_results.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM vocabulary_searches) t) TO '/tmp/vocabulary_searches.json';
COPY (SELECT ROW_TO_JSON(t) FROM (SELECT * FROM z3950_addresses) t) TO '/tmp/z3950_addresses.json';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment