{"action":"created","issue":{"url":"https://api.github.com/repos/onyxfish/csvkit/issues/522","labels_url":"https://api.github.com/repos/onyxfish/csvkit/issues/522/labels{/name}","comments_url":"https://api.github.com/repos/onyxfish/csvkit/issues/522/comments","events_url":"https://api.github.com/repos/onyxfish/csvkit/issues/522/events","html_url":"https://github.com/onyxfish/csvkit/issues/522","id":128356037,"number":522,"title":"csvsql keeps telling me I don't have postgres library","user":{"login":"ddibiase","id":1168397,"avatar_url":"https://avatars.githubusercontent.com/u/1168397?v=3","gravatar_id":"","url":"https://api.github.com/users/ddibiase","html_url":"https://github.com/ddibiase","followers_url":"https://api.github.com/users/ddibiase/followers","following_url":"https://api.github.com/users/ddibiase/following{/other_user}","gists_url":"https://api.github.com/users/ddibiase/gists{/gist_id}","starred_url":"https://api.github.com/users/ddibiase/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ddibiase/subscriptions","organizations_url":"https://api.github.com/users/ddibiase/orgs","repos_url":"https://api.github.com/users/ddibiase/repos","events_url":"https://api.github.com/users/ddibiase/events{/privacy}","received_events_url":"https://api.github.com/users/ddibiase/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/onyxfish/csvkit/labels/question","name":"question","color":"c7def8"}],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":5,"created_at":"2016-01-23T22:17:15Z","updated_at":"2016-01-23T22:49:50Z","closed_at":null,"body":"I'm on OSX and am getting this msg whenever I try to run my csvsql command. Here's the full command I'm using:\r\n\r\n    iconv -f latin1 -t UTF-8 +data/dump/${file}.txt |\r\n    csvcut --tabs --not-columns \"ibis_client\",\"company\" |\r\n    csvsql --db \"postgresql:///import_temp\" --insert --table $file\r\n\r\nHere's the error:\r\n\r\n    You don't appear to have the necessary database backend installed for connection string you're trying to use. Available backends include:\r\n\r\n    Postgresql: pip install psycopg2\r\n    MySQL:      pip install MySQL-python\r\n\r\n    For details on connection strings and other backends, please see the SQLAlchemy documentation on dialects at: \r\n\r\n    http://www.sqlalchemy.org/docs/dialects/\r\n\r\nIt keeps repeating that message (likely for every row that's being created).\r\n\r\nI do have psycopg2 installed correctly. I use Python and pip as installed via Homebrew (easier for me to manage). At first I thought this was an issue finding the correct library paths but everything is linked correctly (as far as I can tell). If I which pip and python both are running from /usr/local/bin.\r\n\r\nI'm also using Postgres.app which is running from the default port.\r\n\r\nThere doesn't seem to be any other issues regarding this, wondering if it's something I'm doing wrong :-/"},"comment":{"url":"https://api.github.com/repos/onyxfish/csvkit/issues/comments/174228339","html_url":"https://github.com/onyxfish/csvkit/issues/522#issuecomment-174228339","issue_url":"https://api.github.com/repos/onyxfish/csvkit/issues/522","id":174228339,"user":{"login":"jpmckinney","id":26463,"avatar_url":"https://avatars.githubusercontent.com/u/26463?v=3","gravatar_id":"","url":"https://api.github.com/users/jpmckinney","html_url":"https://github.com/jpmckinney","followers_url":"https://api.github.com/users/jpmckinney/followers","following_url":"https://api.github.com/users/jpmckinney/following{/other_user}","gists_url":"https://api.github.com/users/jpmckinney/gists{/gist_id}","starred_url":"https://api.github.com/users/jpmckinney/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jpmckinney/subscriptions","organizations_url":"https://api.github.com/users/jpmckinney/orgs","repos_url":"https://api.github.com/users/jpmckinney/repos","events_url":"https://api.github.com/users/jpmckinney/events{/privacy}","received_events_url":"https://api.github.com/users/jpmckinney/received_events","type":"User","site_admin":false},"created_at":"2016-01-23T22:49:50Z","updated_at":"2016-01-23T22:49:50Z","body":"@elfring Using a virtualenv is a best practice and solves a lot of problems encountered when installing things system-wide."}}