Postgres and Open Source Experts

24x7x365 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.

PostgreSQL Date Types: Functions, Formats, and Intervals

This blog post explained date data types, functions, operators, formats, and intervals with the help of appropriate examples.

How to Check/Get PostgreSQL Version

To check which PostgreSQL version is active on your system, users can run “psql –version” command from the command prompt, or the “SELECT VERSION()” command from SQL Shell.

How to Kill a Process ID in PostgreSQL

To kill a process in Postgres, first, find the “pid” for all the processes, and then run the “pg_cancel_backend(pid)” and “pg_terminate_backend(pid)” commands.

Understanding PostgreSQL Sequence Functions

PostgreSQL provides various sequence functions like SETVAL(), NEXTVAL(), CURRVAL(), and LASTVAL() to work with sequences efficiently.

PostgreSQL List Users, Databases, Schemas, Tables

To find the list of users, databases, schemas, or tables, the meta-commands like “\du”, “\l”, “\dn”, and “\dt” are used, respectively.

PostgreSQL: Basic psql Commands

psql is a command-line interface used to perform various database tasks efficiently. For instance, using psql different commands can be executed to access, create, delete, or update a database, table, schema, etc.

PostgreSQL TRUNCATE VS DROP VS DELETE

In Postgres, the TRUNCATE TABLE command only removes the table’s data and preserves the table’s structure. While the DROP TABLE command drops the table’s data and structure permanently.

What Does PostgreSQL regexp_matches() Function Do?

regexp_matches() function takes in the string and the regular expression to be matched as an argument along with an optional flag and returns the first matched substring from the main string.

How to Install and Setup PostgreSQL on Debian 12

Use the “sudo apt install postgresql postgresql-contrib” command to install PostgreSQL from Debian 12’s default repository.

How to Describe Database Objects in PostgreSQL From psql

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