{ "info": { "author": "Joey Sham", "author_email": "sham.joey@gmail.com", "bugtrack_url": null, "classifiers": [], "description": "psql2csv\n========\n\nA library and a CLI to download PostgreSQL schemas and tables\n\nInstallation\n============\n\n.. code:: bash\n\n pip3 install psql2csv\n\nUsage\n=====\n\nCLI\n---\n\nTo run the CLI normally, just run\n\n.. code:: bash\n\n psql2csv\n\n.. code:: bash\n\n Options:\n --dbname TEXT The database name\n --host TEXT URL Endpoint of the database\n --user TEXT Login username\n --password TEXT Login password\n --all Downloads everything\n --schema Downloads a schema\n --table Downloads a table\n --stdout Whether to print which schema and table is downloading\n --help Show this message and exit.\n\nAPI\n---\n\nThere are 3 runnable functions: \\* `download_all <#download_all>`__ \\*\n`download_schema <#download_schema>`__ \\*\n`download_table <#download_table>`__\n\ndownload_all\n~~~~~~~~~~~~\n\n**download_all**\\ (conn, output_folder=\u2018output\u2019,\nexclude_schemas=[\u2018pg_toast\u2019, \u2018pg_temp_1\u2019, \u2018pg_toast_temp_1\u2019,\n\u2018pg_catalog\u2019, \u2018public\u2019, \u2018information_schema\u2019], stdout=False)\n\nDownloads all schemas and all its tables by specifying schema\n\n- conn: input connection or psql2csv.DataBase. If it\u2019s an input\n connection, it\u2019ll eventually be converted to psql2csv.DataBase class\n- output_folder: the name of the folder to place the data\n- exclude_schemas: Which schemas to exclude while downloading\n everything\n- stdout: whether to print which schema and table is downloading. True\n = print\n\ndownload_schema\n~~~~~~~~~~~~~~~\n\n**download_schema**\\ (conn, schema, output_folder=\u2018output\u2019,\nstdout=False)\n\nDownloads schema and its tables by specifying schema\n\n- conn: input connection or psql2csv.DataBase. If it\u2019s an input\n connection, it\u2019ll eventually be converted to psql2csv.DataBase class\n- schema: name of the schema to download\n- output_folder: the name of the folder to place the data\n- stdout: whether to print which schema and table is downloading. True\n = print\n\ndownload_table\n~~~~~~~~~~~~~~\n\n**download_table**\\ (conn, schema, table, output_folder=\u2018output\u2019,\nstdout=False)\n\nDownloads table by specifying schema and table\n\n- conn: input connection or psql2csv.DataBase. If it\u2019s an input\n connection, it\u2019ll eventually be converted to psql2csv.DataBase class\n- schema: name of the schema that the table belongs to\n- table: name of the table to download\n- output_folder: the name of the folder to place the data\n- stdout: whether to print which table is downloading. True = print\n\nVersions\n--------\n\n**1.1.x**\n\n- Added CLI\n\n**1.0.x**\n\n- First publish\n\n\n", "description_content_type": null, "docs_url": null, "download_url": "https://github.com/joeyism/linkedin_scraper/dist/1.1.4.tar.gz", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "http://www.joeyism.com", "keywords": "", "license": "", "maintainer": "", "maintainer_email": "", "name": "psql2csv", "package_url": "https://pypi.org/project/psql2csv/", "platform": "", "project_url": "https://pypi.org/project/psql2csv/", "project_urls": { "Download": "https://github.com/joeyism/linkedin_scraper/dist/1.1.4.tar.gz", "Homepage": "http://www.joeyism.com" }, "release_url": "https://pypi.org/project/psql2csv/1.1.4/", "requires_dist": [ "nprint", "click", "psycopg2" ], "requires_python": "", "summary": "A library and a CLI to download PostgreSQL schemas and tables", "version": "1.1.4" }, "last_serial": 3440089, "releases": { "1.0.0": [ { "comment_text": "", "digests": { "md5": "2216a24827500b64b6f8bd6d69a51f1e", "sha256": "b4f6c1c3028af2ba33fa45ea9f7bfa4667426096cd269dec14e49b71cfbf57aa" }, "downloads": -1, "filename": "psql2csv-1.0.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "2216a24827500b64b6f8bd6d69a51f1e", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5360, "upload_time": "2017-12-24T05:05:25", "url": "https://files.pythonhosted.org/packages/d2/a5/92ebd095800f19218752c4021d260497b58088383eeb1eaa75d7c4a03a17/psql2csv-1.0.0-py2.py3-none-any.whl" } ], "1.0.1": [ { "comment_text": "", "digests": { "md5": "9861ef96ee65a8ada86beaf400e3ba9a", "sha256": "9d19b6aa6c01eb7f1e0a07d02a9bef5792596377871b6d2a7ea8b2737e62f155" }, "downloads": -1, "filename": "psql2csv-1.0.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "9861ef96ee65a8ada86beaf400e3ba9a", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5431, "upload_time": "2017-12-24T05:58:30", "url": "https://files.pythonhosted.org/packages/60/d0/60fe4d8759e802e1b9eb64209ecb2ae5cb9567754ce7258c5c3893f396bd/psql2csv-1.0.1-py2.py3-none-any.whl" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "72b7946c798477033b8e87739edb4ad5", "sha256": "c6de06888657afda0ca6a552c81bd0c8d8062202e603c577e8e2ed06491401e3" }, "downloads": -1, "filename": "psql2csv-1.1.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "72b7946c798477033b8e87739edb4ad5", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 5954, "upload_time": "2017-12-24T06:03:50", "url": "https://files.pythonhosted.org/packages/25/02/06f53ac4e69d9a6408191eeb5ef36edd46d3a7d3bbc32a073e298e016f93/psql2csv-1.1.0-py2.py3-none-any.whl" } ], "1.1.1": [ { "comment_text": "", "digests": { "md5": "7b158d659773cbfff54bbf55f1018d42", "sha256": "cd50c510f1a74f779b562a3c240e309deb427b8cc0381825265730cae5a677ad" }, "downloads": -1, "filename": "psql2csv-1.1.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "7b158d659773cbfff54bbf55f1018d42", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6296, "upload_time": "2017-12-24T06:11:35", "url": "https://files.pythonhosted.org/packages/79/a4/31a5d4fe91938edfcdac3f974f0d649adc6dfb1958f088d5e03c70186259/psql2csv-1.1.1-py2.py3-none-any.whl" } ], "1.1.2": [ { "comment_text": "", "digests": { "md5": "6676844e19ae831b1627af2d5c90655b", "sha256": "0dceb6783e0557ee56549a759e9425a64721cdcab0bbb714b4dbcf088ea536aa" }, "downloads": -1, "filename": "psql2csv-1.1.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "6676844e19ae831b1627af2d5c90655b", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6300, "upload_time": "2017-12-24T06:13:33", "url": "https://files.pythonhosted.org/packages/09/da/5ec1574b84cbad0d5b8c36903a418dc5cfce026d5acaac7d210f0072c662/psql2csv-1.1.2-py2.py3-none-any.whl" } ], "1.1.3": [ { "comment_text": "", "digests": { "md5": "6ec09d71b11a53ef2033f98392f1abc3", "sha256": "5f784ce5c8298330e570028d109a12b8454e247189c63f126124c96071dc0ba0" }, "downloads": -1, "filename": "psql2csv-1.1.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "6ec09d71b11a53ef2033f98392f1abc3", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 6297, "upload_time": "2017-12-24T06:17:14", "url": "https://files.pythonhosted.org/packages/d5/89/639d7f74e2052024449dfb578452e31a216cda46ba36d5d75c7bae36273b/psql2csv-1.1.3-py2.py3-none-any.whl" } ], "1.1.4": [ { "comment_text": "", "digests": { "md5": "a0dc84fc709e3cef048681395ab64975", "sha256": "d3e13cfa1fad7754e2057711785a6993a4c42f6642060dec1203b06796013e61" }, "downloads": -1, "filename": "psql2csv-1.1.4-py3-none-any.whl", "has_sig": false, "md5_digest": "a0dc84fc709e3cef048681395ab64975", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6381, "upload_time": "2017-12-24T06:22:16", "url": "https://files.pythonhosted.org/packages/90/40/3f83db8f1acae0c6f3ea40b94c96294ae35561a03fd2c8d0a0fa6b0a384b/psql2csv-1.1.4-py3-none-any.whl" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "a0dc84fc709e3cef048681395ab64975", "sha256": "d3e13cfa1fad7754e2057711785a6993a4c42f6642060dec1203b06796013e61" }, "downloads": -1, "filename": "psql2csv-1.1.4-py3-none-any.whl", "has_sig": false, "md5_digest": "a0dc84fc709e3cef048681395ab64975", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 6381, "upload_time": "2017-12-24T06:22:16", "url": "https://files.pythonhosted.org/packages/90/40/3f83db8f1acae0c6f3ea40b94c96294ae35561a03fd2c8d0a0fa6b0a384b/psql2csv-1.1.4-py3-none-any.whl" } ] }