Questions tagged [postgresql]

169

votes

2

answers

How to drop multiple columns in PostgreSQL

postgresql

asked 2012-11-20T13:42:39.617

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

12

votes

1

answers

Why does PostgreSQL default everything to lower case?

postgresql case-sensitive

asked 2012-11-16T01:30:44.937

12

votes

4

answers

SQLAlchemy with PostgreSQL and Full Text Search

python postgresql sqlalchemy flask

asked 2012-11-13T12:58:50.233

157

votes

5

answers

Postgresql not creating db with “createdb” as superuser, yet not outputting errors

postgresql psql

asked 2012-11-10T09:54:04.033

79

votes

4

answers

Don't update column if update value is null

sql postgresql null sql-update

asked 2012-11-09T10:02:00.590

77

votes

2

answers

What does regclass mean in Postgresql

postgresql create-table

asked 2012-11-08T12:26:00.290

22

votes

3

answers

Java - date saved as the day before

java postgresql gwt date glassfish

asked 2012-11-07T09:34:31.817

53

votes

4

answers

Passing user id to PostgreSQL triggers

postgresql triggers

asked 2012-11-01T07:09:20.777

8

votes

1

answers

Accessing postgresql server over network in Mac

macos postgresql

asked 2012-10-30T07:17:09.587

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

9

votes

2

answers

Postgresql: Full text search within lob possible?

postgresql search full-text-search

asked 2012-10-29T09:18:43.853

38

votes

2

answers

How do I create a rails migration to remove/change precision and scale on decimal?

ruby-on-rails database ruby-on-rails-3 postgresql

asked 2012-10-29T04:13:18.203

57

votes

8

answers

encoding UTF8 does not match locale en_US; the chosen LC_CTYPE setting requires encoding LATIN1

postgresql encoding opennms

asked 2012-10-29T04:02:39.387

39

votes

5

answers

How do you join two tables on a foreign key field using django ORM?

python database django postgresql orm

asked 2012-10-26T18:18:14.990

8

votes

1

answers

Separate GIS points into groups of points that are close to each other

postgresql gis postgis

asked 2012-10-26T12:52:55.190

12

votes

3

answers

How can I measure the cost of a database index?

sql database postgresql indexing

asked 2012-10-25T21:10:40.273

18

votes

2

answers

Postgres function with list argument and in clause

sql function postgresql plpgsql

asked 2012-10-18T13:39:31.317

30

votes

3

answers

Capistrano with PostgreSQL, error: database is being accessed by other users

ruby-on-rails postgresql capistrano

asked 2012-10-16T22:31:05.423

18

votes

4

answers

Update multiple rows in a table from another table when condition exists

sql postgresql sql-update postgis

asked 2012-10-13T03:06:43.397

200

votes

10

answers

Django-DB-Migrations: cannot ALTER TABLE because it has pending trigger events

python django postgresql django-migrations

asked 2012-10-11T11:06:29.343

67

votes

5

answers

How to insert a record into a table with a column declared with the SERIAL function

sql database postgresql auto-increment postgresql-serial

asked 2012-10-11T09:08:19.583

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

49

votes

9

answers

Error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

postgresql debian

asked 2012-10-08T12:16:02.180

8

votes

1

answers

PostgreSQL indexes creation time

postgresql ddl

asked 2012-10-03T14:25:48.127

11

votes

2

answers

postgresql: CREATE ROLE does not work

ruby-on-rails postgresql

asked 2012-10-02T19:15:55.850

8

votes

2

answers

Liquibase: relation "databasechangeloglock" already exists, using grails plugin and non-default schema

postgresql grails database-migration liquibase

asked 2012-10-02T02:07:26.083

17

votes

3

answers

How can I pool connections using psycopg and gevent?

python postgresql asynchronous gevent psycopg

asked 2012-09-29T04:53:05.213

89

votes

8

answers

Copy a few of the columns of a csv file into a table

postgresql

asked 2012-09-27T09:29:39.827

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

9

votes

2

answers

connection.select_value only returns strings in postgres with pg gem

mysql ruby-on-rails-3 postgresql activerecord pg

asked 2012-09-24T19:04:56.843

25

votes

3

answers

Raising error in postgreSQL

postgresql plpgsql quoting

asked 2012-09-21T10:48:39.700

21

votes

2

answers

Set limit to array_agg()

sql arrays postgresql limit

asked 2012-09-19T15:12:35.493

14

votes

3

answers

Importing files from PostgreSQL to R

r postgresql

asked 2012-09-19T08:17:51.150

11

votes

2

answers

Warning while testing specs on postgres: there is no transaction in progress

ruby-on-rails ruby-on-rails-3 unit-testing postgresql transactions

asked 2012-09-18T17:00:26.703

69

votes

1

answers

Can I rollback a transaction I've already committed? (data loss)

database postgresql data-recovery

asked 2012-09-18T07:29:26.913

8

votes

1

answers

psql hangs right on starting it

postgresql

asked 2012-09-15T17:12:27.023

46

votes

2

answers

Insert trigger to Update another table using PostgreSQL

postgresql triggers

asked 2012-09-10T00:01:05.907

811

votes

8

answers

Insert text with single quotes in PostgreSQL

sql postgresql quotes string-literals

asked 2012-09-07T11:11:11.530

46

votes

3

answers

Combine two columns and add into one new column

sql postgresql null concatenation

asked 2012-09-07T02:36:02.303

19

votes

2

answers

In postgresql, what's the difference a "database" and a "relation"? ('error relation x does not exist', 'error database x already exists')

sql ruby-on-rails postgresql relation

asked 2012-09-02T01:04:07.890

306

votes

7

answers

How to speed up insertion performance in PostgreSQL

sql postgresql bulkinsert sql-insert

asked 2012-08-30T22:39:25.693

47

votes

2

answers

date_trunc 5 minute interval in PostgreSQL

sql postgresql datetime aggregate-functions

asked 2012-08-28T19:05:14.083

8

votes

1

answers

Using Levenshtein function on each element in a tsvector?

postgresql levenshtein-distance fuzzy-search tsvector

asked 2012-08-23T22:38:28.317

33

votes

8

answers

PostgreSQL won't start: "server.key" has group or world access

linux postgresql odoo private-key

asked 2012-08-23T08:30:59.687

60

votes

4

answers

How do I get min, median and max from my query in postgresql?

postgresql

asked 2012-08-22T06:47:19.707

56

votes

10

answers

Postgresql SQL GROUP BY time interval with arbitrary accuracy (down to milli seconds)

postgresql group-by

asked 2012-08-20T21:40:43.800

21

votes

4

answers

PostgreSQL Mountain Lion socket issue

macos postgresql osx-mountain-lion

asked 2012-08-20T05:22:08.097

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

Questions tagged postgresql