Skip to main content

Python操作PostgreSQL

Project description

更新日志

  • 第一版
  • 添加数据时,表名称加入双引号,避免跟关键字冲突

连接PostgreSQL

from pgman import PostgreSQL

pg = PostgreSQL(db="test", user="wauo", password="123456")

name = "people"
pg.make_table(name)

res = pg.exe_sql("select * from people limit 10", query_all=True)
print(res)

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pgman-0.0.2.tar.gz (3.8 kB view details)

Uploaded Source

File details

Details for the file pgman-0.0.2.tar.gz.

File metadata

  • Download URL: pgman-0.0.2.tar.gz
  • Upload date:
  • Size: 3.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.0.0 CPython/3.10.13

File hashes

Hashes for pgman-0.0.2.tar.gz
Algorithm Hash digest
SHA256 cfead2d77b8de38c97f6302d01531196894454051772b7c86d2439c8abbbe8a9
MD5 66dbc923d0a1609e72a10840c473821d
BLAKE2b-256 397e54a0b9b74de58ef6e13a4183fd02419ca6baf0bf6ee75197d9f9ea729759

See more details on using hashes here.

Provenance

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page