Arenadata Postgres
Arenadata Postgres (ADPG) is a commercial distribution of the PostgreSQL database with additional Enterprise functionality, enterprise support and documentation.
TOP-10 popular articles
The simplest way to work with PostgreSQL tables is to use the psql terminal client. This client allows you to enter data queries, pass them to PostgreSQL, and view the results. Queries can also be received from a file or command line arguments. Psql becomes available on each node of the ADPG cluster immediately after its installation.
A common table expression (CTE) is a temporary result of an SQL statement that can be referenced in another SQL statement. CTEs allows you to split complex SQL queries into simpler parts.
PostgreSQL offers two types to store JSON data defined in RFC 7159: JSON and JSONB. To implement efficient query mechanisms for these data types, PostgreSQL also provides the JSONPath data type.
ADPG uses roles to manage database access permissions. A role represents a database user or a group of database users. Roles can own database objects (for example, tables and functions) and allow access and actions on these objects (assign privileges). It is also possible to grant membership in a role to another role to use its privileges.
The dump technique allows you to create a file with SQL commands that recreates a database in the same state as it was at the time the dump was made.
You can use the UNION, INTERSECT, and EXCEPT set operators to combine the results of two queries.
PostgreSQL creates an execution plan for each query. Since the resulting plan is critical to performance, PostgreSQL includes a complex planner that chooses the best plan based on an estimated cost of each alternative option.
The bytea data type allows you to store variable-length binary strings. A binary string is a sequence of octets (bytes).
You can specify a temporary name for a table or a column. This name is called an alias. PostgreSQL assigns aliases during query execution and does not store them in a database or on a disk.
A PostgreSQL subquery is an SQL query nested inside a parent query. A subquery can be nested inside a SELECT, INSERT, UPDATE, DELETE, SET, or DO statement or inside another subquery.