Alex Rivera | Logout

Questions tagged postgresql-9.1

33 questions

Sort by: Newest Votes Active
121
votes
2
answers

How to Disconnect from a database and go back to the default database in PostgreSQL?

postgresql postgresql-9.1 postgresql-9.2
asked 2013-07-31T06:40:56.383
96
votes
6
answers

postgres, ubuntu how to restart service on startup? get stuck on clustering after instance reboot

ubuntu ubuntu-12.04 postgresql-9.1
asked 2013-05-13T06:04:31.740
78
votes
6
answers

Easy way to view postgresql dump files?

database postgresql-9.1 pg-dump
asked 2013-04-25T20:26:29.543
572
votes
6
answers

How to list the tables of schemas in PostgreSQL?

postgresql command psql postgresql-9.1 dbtable
asked 2013-03-26T17:56:59.277
29
votes
6
answers

Alphanumeric case in-sensitive sorting in postgres

postgresql postgresql-9.1
asked 2013-03-15T08:13:20.207
56
votes
4
answers

Postgres query optimization (forcing an index scan)

postgresql indexing query-optimization postgresql-9.1 postgresql-performance
asked 2013-01-28T01:34:47.837
11
votes
3
answers

Connect to remote postgresql server on amazon ec2

postgresql amazon-web-services amazon-ec2 postgresql-9.1
asked 2013-01-27T07:15:33.140
11
votes
3
answers

Postgres concat all

sql postgresql postgresql-9.1
asked 2013-01-21T01:04:31.540
9
votes
1
answers

How to drop multiple triggers in a PostgreSQL 9.1 DB

sql postgresql postgresql-9.1
asked 2013-01-04T20:03:38.207
8
votes
2
answers

PostgresQL Automating VACUUM FULL for bloated tables

postgresql postgresql-9.1 nagios
asked 2012-12-18T11:30:03.817
40
votes
2
answers

How to take backup of functions only in Postgres

sql postgresql postgresql-9.1
asked 2012-12-07T06:22:20.763
190
votes
4
answers

ALTER TABLE, set null in not null column, PostgreSQL 9.1

postgresql null postgresql-9.1
asked 2012-11-30T10:55:57.023
15
votes
1
answers

Create database, tables etc in one script postgresql

sql postgresql postgresql-9.1
asked 2012-11-25T16:07:13.673
104
votes
7
answers

Strange PostgreSQL "value too long for type character varying(500)"

sql database django postgresql postgresql-9.1
asked 2012-11-21T01:28:49.420
15
votes
1
answers

Join a count query on generate_series() and retrieve Null values as '0'

sql postgresql join postgresql-9.1 generate-series
asked 2012-11-16T09:26:22.880
193
votes
9
answers

how to exclude null values in array_agg like in string_agg using postgres?

sql postgresql postgresql-9.1 postgresql-8.4
asked 2012-10-29T13:49:55.747
12
votes
2
answers

Change varchar to boolean in PostgreSQL

postgresql database-design query-optimization storage postgresql-9.1
asked 2012-10-10T16:41:55.960
264
votes
11
answers

How to add column if not exists on PostgreSQL?

postgresql postgresql-9.1 not-exists
asked 2012-09-26T08:20:29.840
15
votes
7
answers

JPA Hibernate Call Postgres Function Void Return MappingException:

hibernate function jpa stored-procedures postgresql-9.1
asked 2012-09-24T01:57:13.387
13
votes
3
answers

Postgresql CITEXT Datatype Issue JPA Hibernate

hibernate postgresql jpa postgresql-9.1
asked 2012-08-20T02:18:22.700
20
votes
1
answers

Most efficient way to retrieve a unique list of keys from all rows of an hstore?

postgresql postgresql-9.1 hstore
asked 2012-08-18T04:48:30.427
14
votes
3
answers

PL/pgSQL SELECT into an array

sql postgresql plpgsql postgresql-9.1
asked 2012-07-31T00:19:11.280
39
votes
2
answers

Is there a "pg_restore --quiet" option like "psql --quiet"?

postgresql postgresql-9.1 psql pg-restore
asked 2012-07-14T16:17:46.610
160
votes
7
answers

Postgres ENUM data type or CHECK CONSTRAINT?

postgresql postgresql-9.1
asked 2012-06-06T22:26:52.800
321
votes
21
answers

I forgot the password I entered during PostgreSQL installation

postgresql postgresql-9.1 forgot-password
asked 2012-06-01T07:14:49.780
13
votes
1
answers

Npgsql: Timeout while getting a connection from the pool

connection connection-pooling npgsql postgresql-9.1
asked 2012-04-05T12:33:55.380
11
votes
3
answers

Create array in SELECT

sql postgresql aggregate aggregate-functions postgresql-9.1
asked 2012-03-20T22:39:09.937
12
votes
2
answers

Java queries against PGPool II cause "unnamed prepared statement does not exist" errors

java postgresql jdbc postgresql-9.1 pgpool
asked 2012-03-15T17:29:21.223
10
votes
2
answers

List all UNLOGGED tables in Postgresql database

postgresql postgresql-9.1
asked 2012-03-14T12:55:34.823
30
votes
2
answers

Postgresql: auto lowercase text while (or before) inserting to a column

postgresql postgresql-9.1
asked 2012-01-28T16:27:12.680
11
votes
3
answers

PostgreSQL: How do I export a function definition to SQL

postgresql postgresql-9.1
asked 2012-01-20T16:11:17.673
10
votes
5
answers

PostgreSQL export large object to client

postgresql postgresql-9.1
asked 2012-01-09T10:36:00.793
16
votes
4
answers

How do I install pgcrypto in postgresql 9.1 on Windows?

postgresql postgresql-9.1
asked 2011-11-03T19:29:21.970