Alex Rivera | Logout

Questions tagged postgresql

628 questions · page 6 of 13

Sort by: Newest Votes Active
9
votes
3
answers

How to get query plan information from Postgres into JDBC

java postgresql jdbc
asked 2011-12-02T12:47:28.303
19
votes
5
answers

Change LC_CTYPE for PostgreSQL and PostGIS use

postgresql locale postgis geodjango
asked 2011-12-02T03:25:18.893
12
votes
8
answers

Is it conceptually right to do a SELECT MAX(id) etc. for finding the last inserted row?

mysql sql postgresql
asked 2011-12-01T17:09:24.477
11
votes
2
answers

PostgreSQL aggregate or window function to return just the last value

sql postgresql aggregate-functions
asked 2011-11-30T02:55:04.283
455
votes
6
answers

Create unique constraint with null columns

sql postgresql database-design null referential-integrity
asked 2011-11-27T21:16:12.893
11
votes
5
answers

How to delete unused sequences?

postgresql ddl sequences
asked 2011-11-25T06:36:45.183
10
votes
3
answers

LISTEN query timeout with node-postgres?

postgresql node.js asynchronous
asked 2011-11-24T20:53:15.683
119
votes
5
answers

PostgreSQL how to see which queries have run

database postgresql pgadmin
asked 2011-11-21T07:01:59.240
41
votes
6
answers

PostgreSQL - create a new DB through pgAdmin UI

postgresql user-interface pgadmin
asked 2011-11-20T10:30:01.407
72
votes
4
answers

Postgres 9.1 vs Mysql 5.6 InnoDB?

mysql postgresql
asked 2011-11-18T11:23:46.003
26
votes
11
answers

Error when pushing data to Heroku: time zone displacement out of range

postgresql heroku taps
asked 2011-11-16T12:19:36.263
251
votes
8
answers

Which data type for latitude and longitude?

postgresql types latitude-longitude postgis
asked 2011-11-16T11:11:58.123
15
votes
4
answers

Nesting Aggregate Functions - SQL

sql postgresql aggregate-functions
asked 2011-11-15T18:47:17.880
10
votes
3
answers

Unable to connect to PostgreSQL server: could not connect to server: Permission denied

linux postgresql
asked 2011-11-15T17:56:57.273
63
votes
3
answers

PostgreSQL WHERE count condition

sql postgresql group-by having
asked 2011-11-14T09:26:16.000
39
votes
8
answers

Any Postgres compatible ORM for Node.js?

postgresql orm node.js
asked 2011-11-07T19:59:34.047
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
174
votes
3
answers

How to return result of a SELECT inside a function in PostgreSQL?

sql database postgresql plpgsql return-query
asked 2011-10-30T15:47:53.953
11
votes
3
answers

Does Dapper work on Mono?

c# mysql postgresql mono dapper
asked 2011-10-28T20:48:02.093
9
votes
2
answers

Postgres 9 super slow simple delete

sql postgresql database-administration
asked 2011-10-24T08:59:28.940
11
votes
1
answers

How to disable triggers in PostgreSQL 9?

postgresql triggers
asked 2011-10-18T10:08:56.377
17
votes
1
answers

Syntax to call a PostgreSQL function that contains an array among its arguments

arrays function postgresql testing
asked 2011-10-14T15:57:20.130
17
votes
4
answers

PostgreSQL under Lion: What's the password?

macos postgresql passwords osx-lion
asked 2011-10-13T19:16:50.653
9
votes
2
answers

How to fetch the continuous list with PostgreSQL in web

postgresql http pagination database-cursor continuous
asked 2011-10-12T21:37:22.910
28
votes
4
answers

Creating Rails 3.1 app with Postgresql database (OSX Lion)

ruby-on-rails ruby-on-rails-3 postgresql
asked 2011-10-12T14:12:45.453
39
votes
4
answers

Pgadmin III Alternative - Windows

windows postgresql erd
asked 2011-10-12T06:47:41.840
607
votes
32
answers

'password authentication failed for user "postgres"'

postgresql
asked 2011-10-08T09:37:43.633
23
votes
3
answers

How to write alter column name migrations with sqlalchemy-migrate?

python sqlite postgresql heroku sqlalchemy-migrate
asked 2011-10-05T10:31:45.570
161
votes
15
answers

Check if a user-defined type already exists in PostgreSQL

postgresql user-defined-types
asked 2011-10-02T06:18:06.217
66
votes
7
answers

DROP FUNCTION without knowing the number/type of parameters?

sql postgresql plpgsql dynamic-sql ddl
asked 2011-10-01T20:54:07.897
61
votes
4
answers

Destroying a Postgres DB on Heroku

postgresql heroku destroy
asked 2011-10-01T20:05:00.187
16
votes
3
answers

How to convert polygon data into line segments using PostGIS

sql postgresql gis postgis
asked 2011-09-29T10:01:02.777
11
votes
1
answers

Will Postgres push down a WHERE clause into a VIEW with a Window Function (Aggregate)?

postgresql where-clause window-functions
asked 2011-09-23T19:30:37.943
24
votes
3
answers

PostgreSQL - Aliases column and HAVING

postgresql having column-alias
asked 2011-09-22T07:23:16.847
28
votes
5
answers

Postgis / Geodjango: Cannot determine PostGIS version for database

django postgresql postgis geodjango
asked 2011-09-20T21:08:03.647
55
votes
4
answers

The forgotten assignment operator "=" and the commonplace ":="

postgresql plpgsql assignment-operator colon-equals
asked 2011-09-18T15:02:29.963
73
votes
3
answers

Postgresql turn null into zero

sql postgresql null max
asked 2011-09-17T04:46:43.397
71
votes
14
answers

Postgres is failing with 'could not open relation mapping file "global/pg_filenode.map" '

macos homebrew postgresql
asked 2011-09-16T14:06:50.843
23
votes
6
answers

Are there any way to execute a query inside the string value (like eval) in PostgreSQL?

sql postgresql select eval
asked 2011-09-15T15:13:01.320
11
votes
1
answers

Running destroy_all on an array?

ruby-on-rails postgresql activerecord rails-activerecord
asked 2011-09-12T03:35:13.357
14
votes
4
answers

Ignore quotation marks when importing a CSV file into PostgreSQL?

postgresql
asked 2011-09-11T04:36:35.653
167
votes
2
answers

Creating a database dump for specific tables and entries Postgres

postgresql
asked 2011-09-09T09:47:53.073
42
votes
2
answers

PostgreSQL: how to resolve "numeric field overflow" problem

postgresql
asked 2011-09-07T20:35:49.090
14
votes
4
answers

Why specify a length for character varying types

database database-design postgresql types varchar
asked 2011-09-06T13:01:44.147
11
votes
3
answers

PostgreSQL Big Text Column Performance

postgresql rails-postgresql
asked 2011-09-05T16:19:19.360
85
votes
5
answers

What is the fastest way to truncate timestamps to 5 minutes in Postgres?

sql performance postgresql datetime
asked 2011-09-04T12:52:15.897
15
votes
3
answers

Does order by in view guarantee order of select?

sql postgresql select
asked 2011-09-02T11:36:32.120
13
votes
3
answers

Postgresql: table name / schema confusion

sql postgresql
asked 2011-08-31T20:09:21.583
25
votes
3
answers

Postgres Query of an Array using LIKE

sql arrays postgresql
asked 2011-08-28T16:15:57.127
54
votes
1
answers

How does PostgreSQL cache statements and data?

postgresql
asked 2011-08-22T01:23:31.707
← Prev page 6 of 13 Next →