Error: b'You need to install postgresql-server-dev-X.Y for building a server-side extension or libpq-dev for building a client-side application.\n'
ERROR: Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-install-7n6622n7/psycopg2/
解决方案:
1.pip install -U pip
2.pipinstall pyscopg2-binary
提前准备安装PostgreSQL数据库
sudo apt-get update
sudo apt-get install postgresql postgresql-client
安装完毕后,系统会创建一个数据库超级用户 postgres,密码为空sudo -i -u postgres
psql
二.实例:
1、创建一个数据库 mydb:
1 |
|
2、为数据库改名:
1 |
|
3、登录数据库:
1 |
|
转载参考:https://www.runoob.com/postgresql/postgresql-tutorial.html