[Chicago] PostgreSQL and Python [Joshua Herman]

Leon Shernoff leon at mushroomthejournal.com
Thu Feb 4 23:02:19 EST 2016


Hi, Joshua

and thanks for your suggestion, but unfortunately that doesn't work and 
is actually something of a known error:
http://stackoverflow.com/questions/8548030/why-does-pip-install-raise-a-syntaxerror

pip install pg8000
raises that syntax error when executed from anaconda's python consoles, 
and anaconda has its own separate installation that's sort of walled off 
from the default installation of Python (and its packages). This is sort 
of the root (so to speak!) of the problem: in the command window I can 
install pg8000 (via pip) for my plain old original Python installation, 
but not (without some fanciness unknown to me) to my Anaconda 
installation. Hence the dependence on Anaconda making packages available 
through its conda command in the console.


Date: Thu, 04 Feb 2016 05:04:47 +0000
From: Joshua Herman <zitterbewegung at gmail.com>
To: The Chicago Python Users Group <chicago at python.org>
Subject: Re: [Chicago] PostgreSQL and Python

Dear Leon,
In anaconda you can still use pip to install packages. In the anaconda
console you can do   pip install pg8000  without the quotes.
Sincerely,
Joshua Herman

On Wed, Feb 3, 2016 at 11:02 PM Leon Shernoff <leon at mushroomthejournal.com>
wrote:

 > and pursuant to working with databases,
 >
 > I'd like to get running with PostgreSQL, and it seems that pg8000 will
 > be the best choice for me since I'm on Windows 7 (Win-64) and Psycopg2
 > doesn't have a version for my environment. However I'm working in
 > Anaconda, and pg8000 isn't one of the packages it has. In fact, it's
 > hard for me to see any way for Python to hook up to PostgreSQL on my
 > machine, though I have it running fine on its own. Does anyone know how
 > I might proceed?

-- 
Best regards,
     Leon

"Creative work defines itself; therefore, confront the work."
      -- John Cage


Leon Shernoff
1511 E 54th St, Bsmt
Chicago, IL  60615

(312) 320-2190



More information about the Chicago mailing list