KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Questions tagged
postgresql
628 questions · page 2 of 13
Follow Tag
Sort by:
Newest
Votes
Active
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
← Prev
page 2 of 13
Next →