PostgreSQL

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X.[4] It is released under the PostgreSQL License, which is an MIT-style license, and is thus free and open source software.

snippet - Convert interval to number in postgresql
4 Feb, 2021
Convert interval to number in postgresql
PostgreSQL
There is a simple function for when you need to extract count of days from interval. It is returned as as double, but converted to integer in this example. You get interval when you subtract two...
snippet - Move tables to another schema in Postgres
26 Nov, 2020
Move tables to another schema in Postgres
PostgreSQL
This form moves the table into another schema. Associated indexes, constraints, and sequences owned by table columns are moved as well.
snippet - Compare values of two tables in PostgreSQL
25 Mar, 2020
Compare values of two tables in PostgreSQL
PostgreSQL
Compare values from columns of multiple tables. This query can be used to compare two tables in such manner in postgres.
snippet - Clone/Duplicate a Table in PostgreSQL
25 Mar, 2020
Clone/Duplicate a Table in PostgreSQL
PostgreSQL
This snippet shows you how you can copy a whole table to another one. Useful if you are about to change data in a table and later need to compare it with EXCEPT.
snippet - PostgreSql return inserted row primary key
28 Nov, 2019
PostgreSql return inserted row primary key
PostgreSQL
When you have primary keys generated by the database not by the application, then you might need it to be returned. In postgres you have to use RETURNING function in your sql query in order to have...
snippet - Get tables names in PostgreSQL
17 Feb, 2012
Get tables names in PostgreSQL
PostgreSQL
Get tables names in PostgreSQL.