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 User in PostgreSQL

To create a user in Postgres, specify the “CREATE USER” command followed by the user name, and after that, assign the privileges to the user using the “WITH” clause.

How to Concatenate a String and a Number in PostgreSQL

PostgreSQL allows us to concatenate a string with a number using a built-in “CONCAT()” function or a pipe concatenation operator “||”.

How to Use ALTER USER Statement in PostgreSQL

A Postgres user's attributes can be changed using the ALTER USER statement. Using the ALTER USER command, we can modify/alter the user's password, privileges, etc..

How to Find Logged In Users in PostgreSQL

To find the logged-in users in Postgres, the “pg_stat_activity” view is used. While to find all Postgres users, a system table named "pg_user" is used.

Postgres Length Functions With Practical Examples

Postgres offers various built-in length functions to calculate the length of a string, such as LENGTH(), BIT_LENGTH(), CHAR_LENGTH(), and BYTE_LENGTH().

How to Change a User to Superuser in PostgreSQL

In PostgreSQL, the ALTER USER and ALTER ROLE statements are used along with the SUPERUSER attribute to change an ordinary user to a superuser.

PostgreSQL DROP CONSTRAINT With Practical Examples

In PostgreSQL, Users must execute the DROP CONSTRAINT with the ALTER TABLE command to drop any particular constraint from a Postgres table.

Is NVL() Function Same as COALESCE() in PostgreSQL

PostgreSQL doesn’t support the NVL() function. In Postgres, a built-in function named COALESCE() is used as an alternative to the NVL() function.

How to Rename Tables in Postgres

To rename a particular table in PostgreSQL, use the RENAME TO clause in conjunction with the ALTER TABLE statement.

How to Create a Superuser in PostgreSQL

To create a superuser in PostgreSQL, users must use the CREATE ROLE or CREATE USER statement along with the SUPERUSER attribute.