Editing PostgreSQL (section)

=== Other querying features ===
* [[Database transaction|Transactions]]
* [[Full-text search]]
* Views
** Materialized views<ref name="materialized_views" />
** Updateable views<ref name="updatable_views" />
** Recursive views<ref name="recursive_views" />
* Inner, outer (full, left, and right), and cross [[Join (SQL)|joins]]
* Sub-[[Select (SQL)|selects]]
** Correlated sub-queries<ref name="Introduction and Concepts" />
* [[Regular expression]]s<ref name="Bernier" />
* [[Hierarchical and recursive queries in SQL#Common table expression|Common table expressions]] and writable common table expressions
* Encrypted connections via [[Transport Layer Security]] (TLS); current versions do not use vulnerable SSL, even with that configuration option<ref name="POODLE" />
* Domains
* [[Savepoint]]s
* [[Two-phase commit protocol|Two-phase commit]]
* The Oversized-Attribute Storage Technique (TOAST) is used to transparently store large table attributes (such as big MIME attachments or XML messages) in a separate area, with automatic compression.
* [[Embedded SQL]] is implemented using preprocessor. SQL code is first written embedded into C code. Then code is run through ECPG preprocessor, which replaces SQL with calls to code library. Then code can be compiled using a C compiler. Embedding works also with [[C++]] but it does not recognize all C++ constructs.