Experts in Postgres and Open Source Infrastructure

24x7, 365 Enterprise services since 1997


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 Use SELF JOIN in PostgreSQL

SELF JOIN is used in the PostgreSQL database to join a table to itself when tables are created in a hierarchy fashion to apply queries on it.

How to Connect a DB Instance Running on PostgreSQL in AWS RDS

Create an AWS RDS DB instance from the service dashboard and use PostgreSQL as its engine. Use Endpoint and username in the “psql” command to connect to it.

How to Connect to My Amazon RDS for PostgreSQL Using IAM Authentication

Create an RDS database with IAM authentication enabled. Attach the IAM role to the EC2 instance and connect to it to generate the SSH key.

How Does LEFT JOIN Work With PostgreSQL

LEFT JOIN is used in the PostgreSQL database to return all the records from the left table and matched records from the right table.

How to Use RIGHT JOIN in PostgreSQL

In PostgreSQL, RIGHT JOIN is used to merge two tables in the database and return all records of the Right table and only matched records from the left one.

How to Create an INDEX in PostgreSQL

In PostgreSQL, indexes can be created using the CREATE INDEX statement followed by the index name and then providing the table name inside the ON condition.

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.