Seo, Technology, Programming, DBMS, Blogging, Wordpress, Plugins, Gadgets, Social Networking

DBMS

SQL, PGPLSQL

LIMIT, OFFSET, ORDER BY and Pagination in PostgreSQL

LIMIT and OFFSET are particularly useful clauses in PostgreSQL. LIMIT, as it’s name suggests, limits the number of rows returned

LIKE and ILIKE are used for pattern matching in PostgreSQL. LIKE is the SQL standard while ILIKE is a useful

In this post we will discuss about the usage of GROUP BY clause and Aggregate Functions in PostgreSQL. PostgreSQL is

In this post we will discuss about the usage of SELECT query in PostgreSQL. SELECT Query form the very basic

This post aims at documenting the complete installation and basic configuration of PostgreSQL 9.4 on an Ubuntu or Linux Mint

This is the first post among the series of posts which demonstrates various tools to set up database pooling in

The PostgreSQL 9 High Availability Cookbook written by Shaun M. Thomas, unlike any other PostgreSQL references which concentrate on Postgres

Though PostgreSQL 9.3 has released, there are people who still uses PostgreSQL 9.2 in combination with PostGIS 2.0. It is

Table of Contents Introduction What is IP Address? IPv4 Address Representation IPv6 Address Representation Supernet, Subnet & Sub-subnet Host Address

In this post, we are going to explore a little of the the raster processing capabilities of the powerful PostgreSQL