{ "info": { "author": "David Lacroix", "author_email": "", "bugtrack_url": null, "classifiers": [ "Development Status :: 4 - Beta", "Intended Audience :: Developers", "License :: OSI Approved :: GNU General Public License v3 (GPLv3)", "Programming Language :: Python :: 2", "Programming Language :: Python :: 3" ], "description": "# csv2pg\nA simple and fast cli application to load a csv into postgres\n\n## Installation\n```bash\npip install csv2pg\n```\n\n## Usage\n```bash\ncsv2pg --help\n```\ncsv2pg expects the same parameter than psql to setup the postgres connection\n```bash\n# Loading data.csv into public.my_table\ncsv2pg -h localhost -p 5432 -U postgres -d postgres public.my_table data.csv --verbose\n# Using postgres env to set connection variables\nPGHOST=mypg.host.com PGPORT=5432 PGDATABASE=mydb PGUSER=myuser csv2pg public.my_table data.csv --verbose\n```\n\n### Dialect discovery\nWith python csv.Sniffer() class the csv parameters like `delimiter`, `quotechar`, `escapechar`, `lineterminator` are automatically detected. They can be overriden with cli options.\n\n### Basic database utilities\ncsv2pg will automatically create the table using the header of the csv file. Caution, the option `--overwrite` will drop the table before inserting the new records in.", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/DavidLacroix/csv2pg", "keywords": "postgres csv", "license": "", "maintainer": "", "maintainer_email": "", "name": "csv2pg", "package_url": "https://pypi.org/project/csv2pg/", "platform": "", "project_url": "https://pypi.org/project/csv2pg/", "project_urls": { "Homepage": "https://github.com/DavidLacroix/csv2pg" }, "release_url": "https://pypi.org/project/csv2pg/1.0.0b2/", "requires_dist": null, "requires_python": ">=2.7", "summary": "A simple and fast cli application to load a csv into postgres", "version": "1.0.0b2" }, "last_serial": 5965182, "releases": { "1.0.0b1": [ { "comment_text": "", "digests": { "md5": "c62713592bf107f6d991c70fc56edd9a", "sha256": "a0a347e69c45f641b4645909ed2f9eecb2e17522b7a0e50c2dc11c7a5d673889" }, "downloads": -1, "filename": "csv2pg-1.0.0b1.tar.gz", "has_sig": false, "md5_digest": "c62713592bf107f6d991c70fc56edd9a", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7", "size": 4006, "upload_time": "2019-10-12T18:07:33", "url": "https://files.pythonhosted.org/packages/d9/ea/36d70bcf62635b7dfb43925db98f1a0caa239e799ab624b89686eda6515c/csv2pg-1.0.0b1.tar.gz" } ], "1.0.0b2": [ { "comment_text": "", "digests": { "md5": "8d8df63169c4a11cf83221ba95900912", "sha256": "a9eac90c2abbdf239be853941d9c51a7ff557852964bdd8fb669b502ec84641b" }, "downloads": -1, "filename": "csv2pg-1.0.0b2.tar.gz", "has_sig": false, "md5_digest": "8d8df63169c4a11cf83221ba95900912", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7", "size": 4040, "upload_time": "2019-10-12T19:35:07", "url": "https://files.pythonhosted.org/packages/79/aa/b26700a3bf87f36db1310d3d85316c8a98e96a3e6271f856b3bf98233253/csv2pg-1.0.0b2.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "8d8df63169c4a11cf83221ba95900912", "sha256": "a9eac90c2abbdf239be853941d9c51a7ff557852964bdd8fb669b502ec84641b" }, "downloads": -1, "filename": "csv2pg-1.0.0b2.tar.gz", "has_sig": false, "md5_digest": "8d8df63169c4a11cf83221ba95900912", "packagetype": "sdist", "python_version": "source", "requires_python": ">=2.7", "size": 4040, "upload_time": "2019-10-12T19:35:07", "url": "https://files.pythonhosted.org/packages/79/aa/b26700a3bf87f36db1310d3d85316c8a98e96a3e6271f856b3bf98233253/csv2pg-1.0.0b2.tar.gz" } ] }