In PostgreSQL, we can use the lower() function to convert uppercase characters to their lowercase equivalent, according to the rules of the database’s locale.
Object-Relational
Get the First Day of the Month in PostgreSQL
We can use the following method in PostgreSQL to return the first day of a given month.
This could be the first day of the current month, or the first day of the month based on a date that we specify.
Getting the first day of the month allows us to perform further calculations on the resulting date, like adding a certain number of days to the start of the month, etc.
Add Hours to a Time Value in PostgreSQL
In PostgreSQL, we can use the + operator to add one or more hours to a time value.
By “time” value, this could be an actual time value, a timestamp, or an interval. We can also add hours to a date value or a date and time combination.
INITCAP() – Convert to Initial Caps in PostgreSQL
In PostgreSQL, we can use the initcap() function to format a string of text to use initial capitals. That is, it converts the first letter of each word to upper case and the rest to lower case.
Subtract Years from a Date in PostgreSQL
In PostgreSQL, we can use the - operator to subtract one or more years from a date.
Detect Whether a Value Contains at Least One Numerical Digit in PostgreSQL
The following example returns all rows that contain at least one numerical digit in PostgreSQL.
Add Years to a Date in PostgreSQL
In PostgreSQL, we can use the + operator to add one or more years to a date.
2 Ways to Delete Duplicate Rows in Oracle
The following options can be used to delete duplicate rows in Oracle Database.
These examples delete duplicate rows but keep one. So if there are three identical rows for example, it deletes two of them and keeps one. This is often referred to as de-duping the table.
PostgreSQL SHOW TABLES Equivalent (psql)
MySQL and MariaDB have a SHOW TABLES statement, which outputs a list of tables and views in a database. PostgreSQL doesn’t have a SHOW TABLES statement, but it does have a command that produces a similar result.
In Postgres, you can use the \dt command to show a list of tables. This is a psql command (psql is the interactive terminal for PostgreSQL).