Postgres and Open Source Experts

In Postgres, the meta-commands like “\d”, “\dt”, “\dv”, “\ds”, and “\df” are used to describe relations, tables, views, sequences, and functions, respectively.

A database object is an entity defined in a database and is used to store or reference data. In Postgres, database objects are created using the CREATE command.

The ARRAY_UPPER() function in PostgreSQL returns the upper bound of the array dimension or the highest index of an array.

The Postgres jsonb_to_record() function takes a top-level JSONB object, converts it into a table record/row, and returns it.

The json_populate_record() function in Postgres converts the JSON object into a data row. It populates the table record from the JSON object.

The JSONB object is provided to the jsonb_object_keys() function as an argument and it returns a column containing all the keys present in that particular JSONB object.

The jsonb_pretty() function returns the beautified version of the provided JSONB value. This function applies proper formatting to the given value.

The jsonb_insert() function inserts a new JSONB value into an already existing JSONB object at a specific location. It takes in 3 parameters essentially and 1 parameter optionally.

The to_ascii() function in PostgreSQL converts the provided string from any valid encoding to the ASCII encoding.

The trim_scale() function takes in a value of a numeric data type and returns the number after trimming zeros from the decimal part of the given numeric value.