Snipplr

(SQL) Convert OID to Bytea - arunpjohny

Mon, 16 Jan 2012 17:45:54 UTC

Convert an oid value into a bytea value.

(SQL) Postgres: Schema resotre - arunpjohny

Fri, 26 Aug 2011 14:54:25 UTC

Restore a postgres schema backup file.

(SQL) Postgres Schema Backup - arunpjohny

Fri, 26 Aug 2011 14:53:04 UTC

Take backup of a schema with large objects

(SQL) Postgres: alter default - arunpjohny

Wed, 06 Jul 2011 17:13:27 UTC

(SQL) Postgres: alter not null constraint - arunpjohny

Wed, 06 Jul 2011 17:11:42 UTC

(SQL) add plpgsql support in postgresql(Linux) - arunpjohny

Tue, 04 Dec 2007 04:03:12 UTC

(SQL) Restore postgres backup file(dumpall) - arunpjohny

Mon, 19 Nov 2007 22:48:10 UTC

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

(SQL) Posgres backups in linux - arunpjohny

Mon, 19 Nov 2007 22:38:32 UTC

(SQL) Get the last date a given month - arunpjohny

Fri, 19 Oct 2007 04:27:09 UTC

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

Fri, 19 Oct 2007 04:26:27 UTC

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 - arunpjohny

Tue, 16 Oct 2007 22:45:41 UTC

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

Tue, 16 Oct 2007 22:44:10 UTC

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 - arunpjohny

Tue, 16 Oct 2007 22:40:34 UTC

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 - arunpjohny

Wed, 26 Sep 2007 22:42:51 UTC

(SQL) datediff function in postgresql - arunpjohny

Fri, 07 Sep 2007 19:53:21 UTC

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

(SQL) Install plpgsql in a database - arunpjohny

Thu, 06 Sep 2007 00:04:59 UTC

Installing plpgsql language in a postgresql database

(SQL) Date Add/Substract - arunpjohny

Wed, 05 Sep 2007 19:31:06 UTC

(SQL) Checking for null in Postgresql - arunpjohny

Wed, 05 Sep 2007 04:11:13 UTC

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