[NOVICE] How extract data from pg_dump'ed files to tsv files?
От | Peng Yu |
---|---|
Тема | [NOVICE] How extract data from pg_dump'ed files to tsv files? |
Дата | |
Msg-id | CABrM6wnGob5mm=5GUP5z6vTm+zsuYLp3aFHZw6u_xhwsNT2Rng@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: [NOVICE] How extract data from pg_dump'ed files to tsv files?
|
Список | pgsql-novice |
Hi, I'd like to extract the tables from the following dump to tsv files. Does anybody know what command I should use to extract the tables into tsv files? Thanks. http://dgidb.org/data/data.sql $ grep -- '^-- ' data.sql -- PostgreSQL database dump -- Dumped from database version 9.6.1 -- Dumped by pg_dump version 9.6.3 -- Data for Name: ar_internal_metadata; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: chembl_molecule_synonyms; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Name: chembl_molecule_synonyms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ssiebert -- Data for Name: chembl_molecules; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Name: chembl_molecules_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ssiebert -- Data for Name: delayed_jobs; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Name: delayed_jobs_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ssiebert -- Data for Name: drug_alias_blacklists; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Name: drug_alias_blacklists_id_seq; Type: SEQUENCE SET; Schema: public; Owner: ssiebert -- Data for Name: drugs; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_aliases; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: source_trust_levels; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: source_types; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: sources; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_aliases_sources; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_attributes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_attributes_sources; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_claims; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_claim_aliases; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_claim_attributes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_claim_types; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: drug_claim_types_drug_claims; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: genes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_aliases; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_aliases_sources; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_attributes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_attributes_sources; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_claim_categories; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_categories_genes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_claims; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_claim_aliases; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_claim_attributes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_claim_categories_gene_claims; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_gene_interaction_claims; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: gene_gene_interaction_claim_attributes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interactions; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interaction_attributes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interaction_attributes_sources; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interaction_claims; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interaction_claim_attributes; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interaction_claim_types; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interaction_claim_types_interaction_claims; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: publications; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interaction_claims_publications; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interaction_types_interactions; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interactions_publications; Type: TABLE DATA; Schema: public; Owner: ssiebert -- Data for Name: interactions_sources; Type: TABLE DATA; Schema: public; Owner: ssiebert -- PostgreSQL database dump complete -- Regards, Peng -- Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-novice
В списке pgsql-novice по дате отправления:
Следующее
От: "David G. Johnston"Дата:
Сообщение: Re: [NOVICE] How extract data from pg_dump'ed files to tsv files?