Top "Postgresql-8.4" questions

This is for PostgreSQL questions specific to version 8.4.

postgresql - can't create database - OperationalError: source database "template1" is being accessed by other users

I logged in to source database template1 and now I can't create database. When I try to create database, I …

postgresql postgresql-8.4
PostgreSQL: between with datetime

I use PostgreSQL 8.4.11 and find strange error. When I query: SELECT "documents_document"."given_on" FROM "documents_document" WHERE (EXTRACT(…

sql postgresql datetime postgresql-8.4
Change Database Collation, Ctype in Postgresql

how do I change Collation, cType to - en_IN from en_US.UTF-8 List of databases Name | Owner | Encoding | …

postgresql postgresql-8.4
How do I get tables in postgres using psycopg2?

Can someone please explain how I can get the tables in the current database? I am using postgresql-8.4 psycopg2.

python psycopg2 postgresql-8.4
How to get the total number of tables in postgresql?

Is there any way by which I can get the total number of tables in a Postgresql database? The postgresql …

database postgresql postgresql-8.4
Options to retrieve the current (on a moment of running query) sequence value

How is it possible to get the current sequence value in postgresql 8.4? Note: I need the value for the some …

postgresql postgresql-8.4
Hashing a String to a Numeric Value in PostgreSQL

I need to Convert Strings stored in my Database to a Numeric value. Result can be Integer (preferred) or Bigint. …

postgresql plpgsql postgresql-8.4
Incrementing a number in a loop in plpgsql

I couldn't find this immediately from the examples. I want to increment a variable in a loop, in a function. …

sql postgresql increment plpgsql postgresql-8.4
Create a temporary table from a selection or insert if table already exist

What is the best way to create a temporary table, if it does not already exist, and add the selected …

postgresql create-table postgresql-8.4
How to save results of postgresql to csv/excel file using psycopg2?

I use driving_distance in postgresql to find distances between all nodes, and here's my python script in pyscripter, import …

postgresql python-2.7 export psycopg2 postgresql-8.4