Alex Rivera | Logout

Questions tagged postgresql

628 questions · page 4 of 13

Sort by: Newest Votes Active
23
votes
6
answers

How can I send email from PostgreSQL trigger?

sql database postgresql pgadmin
asked 2012-08-17T08:49:51.807
8
votes
3
answers

How many recipes can you make with only milk, eggs, butter, flour, sugar, and salt?

sql postgresql
asked 2012-08-16T00:39:42.837
13
votes
4
answers

Postgres performance issues

performance postgresql
asked 2012-08-13T18:55:54.123
17
votes
1
answers

How to execute PostgreSQL RAISE command dynamically

postgresql exception plpgsql
asked 2012-08-11T19:02:30.080
8
votes
1
answers

Strange ordering bug (is it a bug?) when ordering two columns with identical values

sql postgresql sql-order-by limit offset
asked 2012-08-10T15:26:36.710
167
votes
6
answers

PostgreSQL query to return results as a comma separated list

sql postgresql
asked 2012-08-10T09:39:25.527
8
votes
2
answers

Postgres full-text search with synonyms

postgresql full-text-search
asked 2012-08-07T19:47:34.207
129
votes
3
answers

Get Nth element of an array that returns from "string_to_array()" function

arrays database string postgresql type-conversion
asked 2012-08-06T15:44:06.553
21
votes
3
answers

Combine multiple SELECT statements

sql postgresql union
asked 2012-08-06T12:58:06.757
29
votes
2
answers

database-design: table of likes?

mysql database postgresql database-design
asked 2012-08-04T12:28:16.930
29
votes
4
answers

How to set timezone for Postgres psql?

postgresql timezone psql
asked 2012-08-02T14:14:00.130
35
votes
1
answers

PostgreSQL nested CTE and UNION

sql postgresql union common-table-expression
asked 2012-07-31T13:30:16.570
14
votes
3
answers

PL/pgSQL SELECT into an array

sql postgresql plpgsql postgresql-9.1
asked 2012-07-31T00:19:11.280
10
votes
4
answers

How can i setup the path for heroku postgresql app?

ruby-on-rails postgresql heroku osx-mountain-lion pg
asked 2012-07-26T22:58:58.257
8
votes
2
answers

PostgreSQL: The lower the LIMIT, the slower the query

sql postgresql query-optimization sql-execution-plan
asked 2012-07-26T12:30:06.640
16
votes
1
answers

Postgresql changing data directory in ubuntu

sql postgresql ubuntu terminal
asked 2012-07-23T07:59:22.203
73
votes
10
answers

Install psycopg2 on Ubuntu

python postgresql ubuntu
asked 2012-07-20T16:49:41.130
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
8
votes
3
answers

PostgreSQL query/error logging for .sql scripts

sql postgresql logging tee spool
asked 2012-07-12T15:43:25.093
48
votes
5
answers

Postgres won't accept table alias before column name

sql postgresql jodd
asked 2012-07-06T21:17:19.943
15
votes
2
answers

Postgres client locking up when creating new table

postgresql
asked 2012-07-03T07:47:29.913
169
votes
3
answers

Export Postgresql table data using pgAdmin

database postgresql export pgadmin
asked 2012-06-29T06:34:54.540
10
votes
2
answers

concat two int values in postgresql

postgresql integer concatenation
asked 2012-06-25T20:38:54.747
191
votes
4
answers

How to find the size of an array in postgresql

sql arrays postgresql size
asked 2012-06-25T11:45:23.723
22
votes
1
answers

COPY (import) data into PostgreSQL array column

arrays postgresql postgresql-8.4
asked 2012-06-23T14:03:21.730
8
votes
4
answers

Convert bigint to bytea, but swap the byte order

postgresql endianness bytea
asked 2012-06-21T16:06:16.267
19
votes
4
answers

Repair Corrupt database postgresql

postgresql corrupt-data
asked 2012-06-14T09:23:40.053
34
votes
1
answers

Postgres trigger after insert accessing NEW

sql postgresql triggers plpgsql
asked 2012-06-12T16:49:40.137
18
votes
3
answers

Database errors in Django when using threading

python django multithreading postgresql
asked 2012-06-08T12:06:30.287
160
votes
7
answers

Postgres ENUM data type or CHECK CONSTRAINT?

postgresql postgresql-9.1
asked 2012-06-06T22:26:52.800
92
votes
3
answers

Postgres table column name restrictions?

postgresql create-table
asked 2012-06-05T03:58:42.880
257
votes
2
answers

How to create user for a db in postgresql?

database postgresql authentication connection
asked 2012-06-02T09:37:44.490
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
8
votes
3
answers

Postgresql and django - Unix domain socket

django postgresql
asked 2012-05-31T07:51:27.137
35
votes
5
answers

Delete empty rows

sql postgresql
asked 2012-05-18T14:35:30.543
21
votes
7
answers

transpose column headers to rows in postgresql

sql postgresql
asked 2012-05-16T18:55:43.313
9
votes
3
answers

SELECT EXISTS vs. LIMIT 1

python sql postgresql
asked 2012-05-15T10:36:52.107
17
votes
1
answers

Migrate datetime w. timezone in PostgreSQL to UTC timezone to use Django 1.4

django postgresql datetime migration timezone
asked 2012-05-05T12:56:42.380
43
votes
1
answers

Maximum size of "TEXT" datatype in postgresql

python postgresql
asked 2012-05-01T09:40:52.947
21
votes
3
answers

Time zone with daylight savings times in PostgreSQL

postgresql timezone timestamp
asked 2012-04-30T11:41:59.180
9
votes
1
answers

SQLAlchemy: how to filter on PgArray column types?

python sql postgresql sqlalchemy
asked 2012-04-27T03:48:20.087
16
votes
6
answers

PostgreSQL: dump and restore

database postgresql restore dump database-dump
asked 2012-04-26T16:00:18.980
39
votes
2
answers

Grouping AND and OR conditionals in PostgreSQL

sql postgresql parentheses operator-precedence
asked 2012-04-26T10:28:28.623
9
votes
9
answers

Javascript encodeURI like function in postgresql?

postgresql stored-procedures urlencode plpgsql
asked 2012-04-25T14:39:53.663
36
votes
2
answers

Return value from anonymous function postgresql

postgresql anonymous-function plpgsql
asked 2012-04-25T11:48:16.607
23
votes
6
answers

Get size of large object in PostgreSQL query?

sql postgresql blob
asked 2012-04-16T05:57:24.833
22
votes
6
answers

Install libpq-dev on Mac OS X

python django postgresql psycopg2
asked 2012-04-12T21:40:17.210
22
votes
5
answers

How can I convert all columns in my database to case insensitive

postgresql
asked 2012-04-10T09:52:49.870
67
votes
4
answers

POSTGRESQL Foreign Key Referencing Primary Keys of two Different Tables

postgresql foreign-keys
asked 2012-04-09T01:32:53.513
9
votes
4
answers

Postgres 9.0 and pgpool replication : single point of failure?

postgresql failover pgpool
asked 2012-04-07T08:40:19.743
← Prev page 4 of 13 Next →