{
    "info": {
        "author": "",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [
            "Operating System :: Unix",
            "Programming Language :: Unix Shell",
            "Topic :: System :: Archiving :: Backup",
            "Topic :: Utilities"
        ],
        "description": "<!--\nhttps://pypi.org/project/readme-generator/\nhttps://pypi.org/project/python-readme-generator/\n-->\n\n[![](https://img.shields.io/badge/OS-Unix-blue.svg?longCache=True)]()\n\n#### Installation\n```bash\n$ [sudo] pip install postgres-mktempdb\n```\n\n#### Scripts usage\ncommand|`usage`\n-|-\n`mktempdb` |`usage: mktempdb [OPTION]...`\n\n#### Examples\n```bash\n$ mktempdb\ntmp_LH8LqXy8UGlfMR8zfB3todrc4mwC9Sns\n```\n\ndelete temp databases:\n```bash\n$ psql -At -c \"SELECT datname FROM pg_database WHERE datname LIKE 'tmp_%'\" | xargs -L 1 dropdb\n```\n\ndelete temp databases created more than 5 minutes ago:\n```bash\n$ psql -At -c \"SELECT datname FROM pg_database\nWHERE datname LIKE 'tmp_%' AND (pg_stat_file('base/'||oid||'/PG_VERSION')).modification<now()+interval '5 minutes'\" | xargs -L 1 dropdb\n```\n\n<p align=\"center\">\n    <a href=\"https://pypi.org/project/python-readme-generator/\">python-readme-generator</a>\n</p>",
        "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/looking-for-a-job/postgres-mktempdb",
        "keywords": "postgres temp",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "postgres-mktempdb",
        "package_url": "https://pypi.org/project/postgres-mktempdb/",
        "platform": "",
        "project_url": "https://pypi.org/project/postgres-mktempdb/",
        "project_urls": {
            "Homepage": "https://github.com/looking-for-a-job/postgres-mktempdb"
        },
        "release_url": "https://pypi.org/project/postgres-mktempdb/2019.5.23/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "make temp postgres database",
        "version": "2019.5.23"
    },
    "last_serial": 5587272,
    "releases": {
        "2019.5.22": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e93335f3b43dc4ec1494702fadbeb11a",
                    "sha256": "75de47e29fca448e2a41ed4fbefc86cb120663ba2ae89e951dbaa3a0f5a5d9b3"
                },
                "downloads": -1,
                "filename": "postgres-mktempdb-2019.5.22.tar.gz",
                "has_sig": false,
                "md5_digest": "e93335f3b43dc4ec1494702fadbeb11a",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1556,
                "upload_time": "2019-06-07T12:51:59",
                "url": "https://files.pythonhosted.org/packages/ae/93/c581e2f86ab66b73843994ee0456d51f418e594f9caa1782764429ed5dbf/postgres-mktempdb-2019.5.22.tar.gz"
            }
        ],
        "2019.5.23": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "897228dedd62a3eeb5b09640d26036d2",
                    "sha256": "3c24d5b197d1b23c740648260cd1398d8dd4b3221f8f2aac8bef41302c5b6793"
                },
                "downloads": -1,
                "filename": "postgres-mktempdb-2019.5.23.tar.gz",
                "has_sig": false,
                "md5_digest": "897228dedd62a3eeb5b09640d26036d2",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1555,
                "upload_time": "2019-06-07T12:55:01",
                "url": "https://files.pythonhosted.org/packages/9f/2d/464a915373094082e33cbdda7f92971a85d6578baa92d565e522eb9ca3f6/postgres-mktempdb-2019.5.23.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "897228dedd62a3eeb5b09640d26036d2",
                "sha256": "3c24d5b197d1b23c740648260cd1398d8dd4b3221f8f2aac8bef41302c5b6793"
            },
            "downloads": -1,
            "filename": "postgres-mktempdb-2019.5.23.tar.gz",
            "has_sig": false,
            "md5_digest": "897228dedd62a3eeb5b09640d26036d2",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 1555,
            "upload_time": "2019-06-07T12:55:01",
            "url": "https://files.pythonhosted.org/packages/9f/2d/464a915373094082e33cbdda7f92971a85d6578baa92d565e522eb9ca3f6/postgres-mktempdb-2019.5.23.tar.gz"
        }
    ]
}