Tech talk!
Discussing my experiences with technology!
Showing posts with label
postgres
.
Show all posts
Showing posts with label
postgres
.
Show all posts
Tuesday, March 20, 2012
Postgres script - for loop two dimension array using array upper and lower
›
A basic script to loop over an array in psql- CREATE OR REPLACE FUNCTION func1(n character varying, v character varying) RETURNS i...
1 comment:
Saturday, October 15, 2011
Executing Postgres crosstab query as a prepared statement
›
I was executing a crosstab query as a prepared statement in Java(in a GWT app) and getting the following error - PSQLException - Can...
PostgreSQL crosstab query - Rotate a table about a pivot
›
An interesting feature of relational databases(postgres in this case) is the ability to rotate the table about a pivot. So if you have data...
4 comments:
Friday, March 6, 2009
Remote access to PostgreSQL Server
›
Error: "could not connect to Server: Connection refused" The resolution is a five step process : - 1. Firstly, check if your firew...
Tuesday, March 3, 2009
Connecting to an existing database using TurboGears framework
›
Your application would need a DB connection to access the database. A connection is how you tell SQLObject to locate your database. SQLObjec...
›
Home
View web version