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.

How to Drop a Default Value From a Column in PostgreSQL

To drop/remove the default value from a column, you need to use the “DROP DEFAULT” keyword with the assistance of the “ALTER TABLE” command.

INTEGER Data Types in PostgreSQL

PostgreSQL provides several integer data types, such as INTEGER, SMALLINT, and BIGINT. These data types assist us in storing and manipulating whole numbers.

How to Drop a View in PostgreSQL

In Postgres, the DROP VIEW statement allows us to delete one or more views from a database. To do that, use the DROP VIEW statement followed by the view’s name to be deleted.

How the timezone() Function Works in PostgreSQL

In PostgreSQL, the timezone() function converts a timestamp to a different time zone. It retrieves a new timestamp with the same value but in a different time zone.

How to Extract DATE From a TIMESTAMP in PostgreSQL?

In PostgreSQL, the built-in DATE() function, CAST operator, and scope resolution operator “::” are used to extract a date from a TIMESTAMP.

How to Change the Timezone of a Postgres Database

PostgreSQL provides an “ALTER DATABASE” command that is used with the “SET TIMEZONE” clause to change the timezone of a Postgres database.

GREATEST() and LEAST() Functions in PostgreSQL

In PostgreSQL, the GREATEST() and LEAST() are built-in functions used to get the biggest and smallest value from the given data, respectively.

PostgreSQL Data Type Formatting Functions

Postgres provides various built-in formatting functions such as TO_CHAR(), TO_TIMESTAMP(), etc. that allows us to convert data from one type to another based on some valid format.

How to Update an Existing Table in PostgreSQL

In PostgreSQL, the ALTER TABLE command updates the table’s structure, such as adding a new column, renaming a column, changing data type, etc.

How to Alter/Modify a VIEW in PostgreSQL

Postgres, the “CREATE OR REPLACE VIEW” command is used to modify the view’s definition. The ALTER VIEW command allows us to alter the view’s auxiliary properties.