Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

New posts in postgresql-9.2

Easy way to have return type be SETOF table plus additional fields?

Moving the data from transaction table to history table to increase insert performance, postgres

postgresql postgresql-9.2

Replication with pgadmin+slony+ubuntu

PostgreSQL: return a select statement in a procedure

Why does PostgreSQL not use my index to do text prefix search under certain collations?

How we can make “statement_timeout” work inside a function?

postgresql postgresql-9.2

Subselect on array_agg in postgresql

Query on subquery that gets tables' names

PostgreSQL: multiple LEFT JOIN with multiple conditions

Is it a good thing to Raise Exceptions intentionally in PostgreSQL?

Return a Record of Rows in PostgreSQL

postgresql postgresql-9.2

How to query multiple COUNT(*) with good performance

Postgres text column that only allows/converts to lowercase and no special characters such as: Ñöáè

psql: FATAL: PAM authentication failed for user

Sliding 1-hour periods aggregation query

PostgreSQL 9.2 10x slower than MySQL 5.5? [closed]

Rails 4 UUID as ID with default value

Postgres.app upgrade, now Rails app won't start

PG::ConnectionBad FATAL: database "myapp_development" does not exist

Import CSV into Postgres and update/replace any fields if need so