Postgres and Open Source Experts

Anytime. Anywhere. 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 Create User With Password

In PostgreSQL, the “CREATE USER” command is used to create a new user. To create a user with the password, execute this command with the “PASSWORD” attribute.

PostgreSQL Create Table From CSV File

In PostgreSQL, creating a table from a CSV file means importing a CSV file into the Postgres table. For this, execute the COPY command to create a Postgres table via the CSV file.

How to Concatenate Multiple Arrays in PostgreSQL

PostgreSQL provides a built-in function named ARRAY_CAT() and a concatenation operator “||” that assists us in concatenating multiple arrays into a single array.

How to Set the Default User Password in PostgreSQL

Execute the “ALTER USER” or “ALTER ROLE” command, followed by the default user name and the PASSWORD attribute to set the default user password in PostgreSQL.

How to Round Timestamps in PostgreSQL

In PostgreSQL, the DATE_TRUNC() function is a convenient way for truncating/rounding the timestamps to the desired level of precision.

How to Fix “Permission Denied” Error While Importing a CSV File in PostgreSQL

Sometimes a “Permission Denied” error occurs while importing a CSV file into a Postgres table. To fix this error, you need to change the file reading permissions.

How to Add/Set a Default Value to a Column in PostgreSQL

In Postgres, the DEFAULT keyword is used with the help of CREATE TABLE or ALTER TABLE statement to set a default value to a column.

How to Extract Year From DATE in PostgreSQL

To extract a year from a date, the built-in EXTRACT() and DATE_PART() functions are used in Postgres. To do so, pass the “YEAR" and the timestamp as arguments to any of these functions.

PostgreSQL DELETE CASCADE With Examples

In PostgreSQL, the DELETE CASCADE feature allows us to delete the records associated with some other tables (via foreign key constraints).

How to Group by Month in PostgreSQL

In Postgres, the EXTRACT(), DATE_TRUNC(), and DATE_PART() functions are used to extract the month from a date field and then use the GROUP BY clause to group the results by month.