Tags

PostgreSQL data types, sql queries, functions, views

PostgreSQL template0 vs template1 Database

In PostgreSQL, we have two default databases, template0 and template1. Sometimes users are confused about why there are two default databases. In this post, we will learn why these two databases are important and what their uses are in PostgreSQL. template1 database Whenever we create a new database in PostgreSQL, the system needs to find a default database from which all the default tables, ...

Continue Reading

PostgreSQL Bigserial datatype Guide

PostgreSQL is the most advanced open source database. PostgreSQL supports many data types and one of the special datatype is bigserial data type. Bigserial data type is used for creating autoincrement columns. PostgreSQL supports 3 datatypes for creating autoincrement columns. smallserial serial bigserial All three datatypes are used for autoincrement fields. All three datatypes have diffe...

Continue Reading