Top "Postgresql-9.2" questions

for PostgreSQL questions specific to version 9.2.

What is the maximum number of columns in a PostgreSQL select query

Do you know what the maximum number of columns that can be queried in Postgresql? I need to know this …

sql postgresql postgresql-9.2
Conversion array types

I have in table column, which type is CHARACTER VARYING[] (that is array) I need concatenate existed rows whith other …

postgresql postgresql-9.2
How do i create postgres to oracle dblink?

How do I create dblink in postgres 9.2 ? I want to be able to use it using @ link in oracle? I …

postgresql oracle11g postgresql-9.2 dblink
Getting Affected Rows by UPDATE statement in RAW plpgsql

This has been asked multiple times here and here, but none of the answers are suitable in my case because …

postgresql plpgsql optimistic-concurrency postgresql-9.2
How to change the template database collection coding

I want build new postgreSQL database by: CREATE DATABASE newdb WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE = pg_default LC_…

postgresql postgresql-9.2
How to force drop index relation in postgresql?

In PostgreSQL 9.2 / PostGIS 2.0.2 I had an index on a spatial column, created with CREATE INDEX tiger_data_sld_the_geom_…

postgresql postgis postgresql-9.2
Return SETOF rows from PostgreSQL function

I have a situation where I want to return the join between two views. and that's a lot of columns. …

postgresql plpgsql dynamic-sql postgresql-9.2
Importing .csv with timestamp column (dd.mm.yyyy hh.mm.ss) using psql \copy

I'm trying to import data from a .csv file into a postgresql 9.2 database using the psql \COPY command (not the …

postgresql csv timestamp psql postgresql-9.2
The local psql command could not be located

I'm following the instructions found here. When I try to run $ heroku pg:psql or $ heroku pg:psql HEROKU POSTGRESQL_…

sql windows postgresql heroku postgresql-9.2
Connection refused (PGError) (postgresql and rails)

I keep getting this error when i try to run my localhost using "$rails s": (Mac OSX 10.8.3) (ruby 2.0.0p195 (2013-05…

ruby-on-rails postgresql postgresql-9.1 postgresql-9.2 rails-postgresql