for PostgreSQL questions specific to version 9.1.
I have read other posts, when searching, an answer to this question. I am using PostgreSQL 9.1, and created extension 'citext' …
postgresql-9.1I 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-postgresqlI am trying to create crosstab queries in PostgreSQL such that it automatically generates the crosstab columns instead of hardcoding …
postgresql plpgsql dynamic-sql postgresql-9.1 crosstabI am using PostgreSQL 9.1 and need help with concatenating multiple rows in one. I need to do that in 2 tables. …
sql postgresql postgresql-9.1If PostgreSQL's count(*) is always slow how to paginate complex queries? Making triggers doesn't seem to be a good solution …
performance postgresql postgresql-9.1In the databases course that I did during my education (approx. 4 years ago), I thought that it is recommended avoiding …
sql foreign-keys primary-key postgresql-9.1 sqldatatypesI'm using PostgreSQL 9.1 and have to to grant "create schema" ON database to a user. How can I do that?
postgresql postgresql-9.1 roleI have a procedure that contains code like this: processStart := current_timestamp; -- run statement(s) processEnd := current_timestamp; elapsed := …
postgresql postgresql-9.1 intervalsI am new to PostgreSQL. Suppose I have a table as under colorname Hexa rgb rgbvalue Violet #8B00FF r 139 …
postgresql pivot postgresql-9.1Using a Postgresql URL connection string in the format of: postgresql://user:secret@localhost How do I handle special characters …
postgresql url connection-string postgresql-9.1