{"id":50157,"library":"jackc-pgconn","title":"pgconn - Low-Level PostgreSQL Driver","description":"Package pgconn is a low-level PostgreSQL database driver for Go.","status":"active","version":"1.14.3","language":"go","source_language":null,"source_url":"https://github.com/jackc/pgconn","tags":["postgresql","database","driver","low-level"],"install":[{"cmd":"go get github.com/jackc/pgconn","lang":"bash","label":"Install github.com/jackc/pgconn"}],"dependencies":[],"imports":[{"symbol":"pgconn","correct":"github.com/jackc/pgconn"}],"quickstart":{"code":"package main\n\nimport (\n\t\"context\"\n\t\"fmt\"\n\t\"log\"\n\t\"github.com/jackc/pgconn\"\n)\n\nfunc main() {\n\tconn, err := pgconn.Connect(context.Background(), \"postgres://user:pass@localhost:5432/dbname\")\n\tif err != nil {\n\t\tlog.Fatal(err)\n\t}\n\tdefer conn.Close(context.Background())\n\n\tresult := conn.ExecParams(context.Background(), \"SELECT 1\", nil, nil, nil, nil)\n\tfmt.Println(\"Command tag:\", result.CommandTag)\n}","lang":"go","description":"Connect to PostgreSQL and execute a simple query."},"warnings":[{"fix":"Use github.com/jackc/pgx/v5 for connection pooling and prepared statements.","message":"pgconn is low-level; prefer pgx for higher-level features.","severity":"gotcha","affected_versions":"*"}],"env_vars":null,"search_vec":"'databas':15,20 'driver':6,16,21 'go':18 'level':4,13,24 'low':3,12,23 'low-level':2,11,22 'packag':7 'pgconn':1,8 'postgresql':5,14,19","created_at":"2026-06-15T04:42:37.022649+00:00","updated_at":"2026-06-15T04:42:37.022649+00:00","problems":[],"ecosystem":"go","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/jackc/pgconn","github":"https://github.com/jackc/pgconn","docs":"https://pkg.go.dev/github.com/jackc/pgconn#section-documentation","changelog":null,"pypi":null,"npm":null,"openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-15","next_check":"2026-12-12","install_tag":null}}