Snipplr - arunpjohny

(SQL) add plpgsql support in postgresql(Linux)

Tue, 04 Dec 2007 04:03:12 GMT

(SQL) Restore postgres backup file(dumpall)

Mon, 19 Nov 2007 22:48:10 GMT

Restore a postgres backup file created using pg_dumpall command. Login as postgres user

(SQL) Posgres backups in linux

Mon, 19 Nov 2007 22:38:32 GMT

(SQL) Get the last date a given month

Fri, 19 Oct 2007 04:27:09 GMT

(SQL) Add a interval to a given date in postgresql

Fri, 19 Oct 2007 04:26:27 GMT

Add a given interval to a date. The intervals can be year, month or day

(SQL) Get name of the weekday of a date in Postgresql

Tue, 16 Oct 2007 22:45:41 GMT

(SQL) Function to get year from a date in Postgresql

Tue, 16 Oct 2007 22:44:10 GMT

This kind of functions will be use full if we are migrating a database from one provider to another like from MS SQL Server to Postgresql.

(SQL) Difference between two dates in Postgresql

Tue, 16 Oct 2007 22:40:34 GMT

Getting the difference between two dates in Postgresql. The difference can be in days, months or years. For difference in days, months or years pass day, month or year as the first argument

(SQL) Postgresql : Alter the datatype of a column

Wed, 26 Sep 2007 22:42:51 GMT

(SQL) datediff function in postgresql

Fri, 07 Sep 2007 19:53:21 GMT

A function which will give the difference between two dates in days, month or years.

(SQL) Install plpgsql in a database

Thu, 06 Sep 2007 00:04:59 GMT

Installing plpgsql language in a postgresql database

(SQL) Type Cast

Wed, 05 Sep 2007 19:36:06 GMT

Cast the given value from one data type to another

(SQL) Date Add/Substract

Wed, 05 Sep 2007 19:31:06 GMT

(SQL) Date Parts

Wed, 05 Sep 2007 04:13:34 GMT

(SQL) Checking for null in Postgresql

Wed, 05 Sep 2007 04:11:13 GMT

Checking for null value and assigns a default value if the field is null