Snipplr

(SQL) Convert OID to Bytea - arunpjohny

Mon, 16 Jan 2012 17:45:54 GMT

Convert an oid value into a bytea value.

(SQL) Postgres: Schema resotre - arunpjohny

Fri, 26 Aug 2011 14:54:25 GMT

Restore a postgres schema backup file.

(SQL) Postgres Schema Backup - arunpjohny

Fri, 26 Aug 2011 14:53:04 GMT

Take backup of a schema with large objects

(SQL) SQL Update With Join - lostumbrellas

Tue, 16 Aug 2011 12:59:48 GMT

(SQL) Postgres: alter default - arunpjohny

Wed, 06 Jul 2011 17:13:27 GMT

(SQL) Postgres: alter not null constraint - arunpjohny

Wed, 06 Jul 2011 17:11:42 GMT

(SQL) Postgres get table schema with columns - djmornyc

Thu, 09 Dec 2010 06:08:50 GMT

Get table schema with columns via sql.

(SQL) web2py SQL for performance - lrivers

Sun, 28 Nov 2010 06:05:26 GMT

This is the SQL code that generates the report side (the web2py version also updates the rows in the minute interval with the id of a summary table that gets a row inserted with the summary from that period)

(SQL) Create Postgres DB/user - insanedreamer

Wed, 17 Nov 2010 10:30:48 GMT

(SQL) Postgres replace - jturmel

Wed, 29 Apr 2009 14:54:23 GMT

(SQL) Adding GIS Support to Postgresql - kungfoo

Mon, 30 Mar 2009 10:47:30 GMT

* be postgres user

(SQL) Copy selection from one table to another with changes - janetmck

Mon, 08 Dec 2008 11:32:01 GMT

(SQL) Delete many functions - robe

Fri, 05 Dec 2008 00:38:57 GMT

(SQL) Functions in postgres - mavallad

Thu, 21 Aug 2008 13:42:18 GMT

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

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

Mon, 19 Nov 2007 22:38:32 GMT

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

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

Tue, 16 Oct 2007 22:45:41 GMT

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

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

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