Editing PostgreSQL (section)

=== Interfaces ===
PostgreSQL supports a binary [[communication protocol]] that allows applications to connect to the database server. The protocol is versioned (currently 3.0, as of PostgreSQL 7.4) and has a detailed specification.<ref>{{cite web
	| url = https://www.postgresql.org/docs/current/protocol.html
	| title = Frontend/Backend Protocol
    | author = <!--Not stated-->
	| website = postgresql.org
	| date = November 9, 2023
 | access-date = 2023-12-17
	| quote = This document describes version 3.0 of the protocol, implemented in PostgreSQL 7.4 and later.
}}</ref>

The official client implementation of this communication protocol is a [[C (programming language)|C]] [[API]], libpq.<ref>{{cite web
	| url = https://www.postgresql.org/docs/16/libpq.html
	| title = libpq
    | author = <!--Not stated-->
	| website = postgresql.org
	| date = November 9, 2023
 | access-date = 2023-12-17
}}</ref> In addition, the officially supported [[ECPG]] tool allows SQL commands to be embedded in C code.<ref>{{cite web
	| url = https://www.postgresql.org/docs/16/ecpg.html
	| title = Embedded SQL in C
    | author = <!--Not stated-->
	| website = postgresql.org
	| date = November 9, 2023
 | access-date = 2023-12-17
}}</ref> Both are part of the standard PostgreSQL distribution.<ref>{{cite web
	| url = https://www.postgresql.org/docs/16/client-interfaces.html
	| title = Client Interfaces
    | author = <!--Not stated-->
	| website = postgresql.org
	| date = November 9, 2023
 | access-date = 2023-12-17
}}</ref>

Third-party libraries for connecting to PostgreSQL are available for many [[programming language]]s, including [[C++]],<ref>{{cite web|title=libpqxx|url=https://pqxx.org/development/libpqxx/|access-date=April 4, 2020}}</ref> [[Java (programming language)|Java]],<ref>{{cite web|title=PostgreSQL JDBC Driver|url=https://jdbc.postgresql.org/|access-date=April 4, 2020}}</ref> [[Julia (programming language)|Julia]],<ref>{{Cite web|date=2021-06-30|title=[ANN] PostgresORM.jl: Object Relational Mapping for PostgreSQL|url=https://discourse.julialang.org/t/ann-postgresorm-jl-object-relational-mapping-for-postgresql/63847|access-date=2021-08-26|website=JuliaLang|language=en}}</ref><ref>{{Cite web|title=GitHub - invenia/LibPQ.jl: A Julia wrapper for libpq|url=https://github.com/invenia/LibPQ.jl|access-date=2021-08-26|website=GitHub|language=en}}</ref><ref name="PL/Julia" /> [[Python (programming language)|Python]],<ref name="psycopg2" /> [[Node.js]],<ref>{{cite web|title=node-postgres|url=https://node-postgres.com/|access-date=April 4, 2020}}</ref> [[Go (programming language)|Go]],<ref>{{cite web |title=SQL database drivers |url=https://github.com/golang/go/wiki/SQLDrivers#drivers |website=Go wiki |publisher=golang.org |access-date=June 22, 2015}}</ref> and [[Rust (programming language)|Rust]].<ref>{{cite web|title=Rust-Postgres|url=https://crates.io/crates/postgres|access-date=April 4, 2020}}</ref>