Questions tagged [postgresql]

51

votes

2

answers

store postgresql result in bash variable

bash postgresql variables

asked 2013-03-06T08:53:31.540

65

votes

1

answers

Why psql can't find relation name for existing table?

postgresql schema psql

asked 2013-03-06T02:45:23.390

87

votes

5

answers

How to add a variable number of hours to a date in PostgreSQL?

sql postgresql datetime

asked 2013-03-01T14:34:37.023

191

votes

7

answers

postgresql port confusion 5433 or 5432?

postgresql port psql

asked 2013-02-26T22:11:12.733

9

votes

4

answers

Rails seed: How to truncate DB table?

sql ruby-on-rails postgresql

asked 2013-02-26T21:34:21.067

12

votes

1

answers

Should I temporarily disable foreign key constraints? How?

sql database postgresql foreign-keys

asked 2013-02-21T15:57:39.103

141

votes

3

answers

Options to retrieve the current (on a moment of running query) sequence value

postgresql postgresql-8.4

asked 2013-02-14T23:39:13.237

8

votes

4

answers

How well is postgres handling duplicates?

postgresql

asked 2013-02-07T14:11:39.670

9

votes

1

answers

Select For Update statement in PostgreSql

sql postgresql

asked 2013-02-05T14:46:39.833

11

votes

2

answers

Postgres Timestamp

database postgresql timezone timestamp

asked 2013-01-30T22:40:21.940

20

votes

3

answers

How to get only date/month part from a date in postgres SQL

sql postgresql

asked 2013-01-29T19:16:18.453

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

2

answers

PostgreSQL ERROR: function to_tsvector(character varying, unknown) does not exist

sql postgresql types casting full-text-search

asked 2013-01-25T14:18:02.867

11

votes

4

answers

How do I migrate PostgreSQL strings to a text type?

postgresql jpa

asked 2013-01-24T23:30:02.150

18

votes

2

answers

PostgreSQL with Homebrew on Mac

postgresql osx-mountain-lion

asked 2013-01-24T20:35:28.710

14

votes

2

answers

PostgreSQL - relation [table] does not exist

postgresql

asked 2013-01-23T20:49:41.073

204

votes

11

answers

PostgreSQL: Export the schema of a database

database postgresql export schema database-schema

asked 2013-01-23T17:57:18.810

16

votes

2

answers

Register and run PostgreSQL 9.0 as Windows Service

postgresql

asked 2013-01-23T16:35:30.227

8

votes

2

answers

Why Does "setval()" Fail With "relation ... does not exist"?

postgresql

asked 2013-01-23T16:08:58.260

49

votes

2

answers

customize pager in psql

postgresql command-line psql pager

asked 2013-01-23T07:02:04.313

11

votes

3

answers

Postgres concat all

sql postgresql postgresql-9.1

asked 2013-01-21T01:04:31.540

9

votes

1

answers

Should one store a search_data tsvector in the same table or external table?

performance postgresql full-text-search

asked 2013-01-21T00:27:53.840

10

votes

1

answers

Sqlalchemy complains that foreign key doesn't exist but actually it exists

python postgresql sqlalchemy

asked 2013-01-19T13:01:14.257

17

votes

1

answers

ERROR: function date_trunc(timestamp without time zone) does not exist

sql postgresql datetime

asked 2013-01-15T15:27:38.593

20

votes

4

answers

How to use subquery in django?

django postgresql django-queryset

asked 2013-01-15T04:33:27.877

40

votes

2

answers

nth percentile calculations in postgresql

function postgresql percentile

asked 2013-01-14T10:18:28.997

9

votes

2

answers

PostgreSQL equivalent of Oracle's PERCENTILE_CONT function

oracle-database function postgresql percentile

asked 2013-01-13T02:14:13.580

39

votes

2

answers

Cannot create a new table after "DROP SCHEMA public"

database postgresql database-schema create-table sql-drop

asked 2013-01-11T20:08:02.403

9

votes

3

answers

Does PostgreSQL support precision and scale for Rails?

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

asked 2013-01-11T03:23:48.763

11

votes

1

answers

Grant privileges to all users, current and future

postgresql database-design privileges

asked 2013-01-09T20:56:43.650

177

votes

5

answers

How to create function that returns nothing

database postgresql plpgsql void

asked 2013-01-08T14:09:04.170

38

votes

7

answers

How to fix pg_dump version mismatch errors?

postgresql osx-mountain-lion uninstallation pg-dump

asked 2013-01-05T05:23:08.043

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

10

votes

1

answers

Mysql vs Oracle XE vs Postgresql . Scalability and performance, which to chose?

mysql oracle-database postgresql database-performance

asked 2012-12-19T12:08:21.847

8

votes

2

answers

PostgresQL Automating VACUUM FULL for bloated tables

postgresql postgresql-9.1 nagios

asked 2012-12-18T11:30:03.817

22

votes

2

answers

Insert values if records don't already exist in Postgres

sql postgresql

asked 2012-12-17T16:55:49.350

26

votes

1

answers

Junction tables vs foreign key arrays?

arrays postgresql many-to-many junction-table

asked 2012-12-12T12:10:38.313

13

votes

1

answers

PostgreSql -> CTE + UPDATE + DELETE -> not expected result, why?

postgresql common-table-expression

asked 2012-12-10T18:14:10.367

13

votes

2

answers

Prepared Statement on Postgresql in Rails

sql ruby-on-rails ruby-on-rails-3 postgresql prepared-statement

asked 2012-12-10T17:05:14.233

9

votes

5

answers

rewrite Hibernate query without huge list parameter

java sql hibernate postgresql

asked 2012-12-10T10:14:37.990

9

votes

4

answers

Minimal postgres instance for testing

java postgresql testing jdbc

asked 2012-12-07T22:22:44.650

16

votes

2

answers

Incrementing a number in a loop in plpgsql

sql postgresql increment plpgsql postgresql-8.4

asked 2012-12-07T20:58:08.940

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

40

votes

4

answers

Getting SQLAlchemy to issue CREATE SCHEMA on create_all

python postgresql sqlalchemy

asked 2012-12-03T05:41:30.347

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

9

votes

4

answers

Heroku push of django app gets "No module named psycopg2.extensions"

django postgresql heroku

asked 2012-11-29T06:27:03.637

15

votes

1

answers

Create database, tables etc in one script postgresql

sql postgresql postgresql-9.1

asked 2012-11-25T16:07:13.673

8

votes

0

answers

Getting Postgresql Running In Mac: Database "postgres" does not exist

macos postgresql postgresql-9.2

asked 2012-11-22T15:27:15.443

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

Questions tagged postgresql