Experts in Postgres and Open Source Infrastructure

24x7, 365 Enterprise services since 1997

Education

Professional Postgres and Open Source support

Command Prompt, Inc., is the oldest Postgres Company in North America and one of the oldest Open Source firms still operating today. We serve our clients with best in class expertise and professionalism. You can read more about support and services here:


You have landed at the largest single source of Postgres education blogs in the world. At Command Prompt, we believe deeply that the education of the community is critical to the continued success of Postgres and related technologies. We hope you find content you are looking for and don't hesitate to Contact us today for all your Postgres and Open Source consulting and support needs.

How to Create a Materialized View in PostgreSQL

To create a materialized view in Postgres, execute the CREATE MATERIALIZED VIEW statement along with the AS keyword followed by the base query.

How to Alter an INDEX in PostgreSQL

The index can be changed in PostgreSQL using an ALTER INDEX statement containing the name of the index and then adding conditions to be applied to change it.

What Does the nextval() Function Do in PostgreSQL

In PostgreSQL, the nextval() function fetches the next value from the sequence to add the incremented value to the existing value of the sequence.

How to Drop an INDEX in PostgreSQL

In PostgreSQL, indexes can be dropped using the DROP INDEX command followed by the index name or names for dropping multiple indexes using a single query.

How to Setup ODBC Drivers for PostgreSQL

To set up ODBC drivers for PostgreSQL, download the executable file and install it on the system. After that, configure the driver by adding a data source to it.

How Does ROLLUP Work in PostgreSQL

The ROLLUP is the sub-clause of the GROUP BY in PostgreSQL which assumes the hierarchy among the columns to reduce the number of subsets in the report.

How to Use CROSS JOIN in PostgreSQL

CROSS JOIN is used in the PostgreSQL database to return the cartesian product of the two tables on which the CROSS JOIN is applied.

How to Calculate Percentiles in PostgreSQL

PERCENT_CONT and PERCENT_DISC are analytic functions that are used to calculate the percentile/median in the PostgreSQL database.

How to Continue a Loop in PostgreSQL

In PostgreSQL, the CONTINUE statement is used to skip iterations of the loop and its syntax included the label of the loop and conditions.

PL/pgSQL Exit Statement: How to Terminate a Loop

Terminating the loop before its actual ending point or condition can be done using the “Exit” statement in the PostgreSQL query.