KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
postgresql
628 questions · page 6 of 13
Follow Tag
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 →