Popular Postgresql Programming Tips
Hierarchical data in postgres
Chris Farmiloe
·
4 responses
·
postgres, postgresql, ltree
Start and Stop PostgreSQL manually on Mac OS X
Carlo Mallone
·
0 responses
·
postgresql, postgres, server
Use IN instead of ANY in PostgreSQL
Michał Czyż
·
6 responses
·
performance, postgresql
Rails 4 & the PostgreSQL Array data type
Stuart Liston
·
11 responses
·
active record, postgres, array, postgresql
Things I learned while writing a Dockerfile
Murphy Randle
·
7 responses
·
tip, sudo, gotcha, postgresql
Install PostgreSQL 9.2 on OS X Mountain Lion
Phil Cohen
·
16 responses
·
ruby, rails, osx, macports
Make postgres default to UTF8
katy lavallee
·
2 responses
·
postgresql
Backup and restore a postgresql database using commandline
Saji Nediyanchath
·
0 responses
·
backup, restore, postgresql
PostgreSQL with docker on OS-X
eranga bandara
·
0 responses
·
osx, postgresql, boot2docker, docker
Dump PostgreSQL without owner and privileges
Bartłomiej Danek
·
0 responses
·
postgresql, linux server administration
Install Postgresql on Mountain Lion
Andrey Deryabin
·
7 responses
·
homebrew, postgresql
Backup and recover a Postgres DB using wal-e
Daniel Alejandro Gaytán Valencia
·
1 response
·
daniel-g, wal, wal-e, postgresql
Improve case-insensitive queries in Postgres using smarter indexes
Mike Hall
·
1 response
·
postgres, database, indexes, postgresql
Incremental backups for PostgreSQL
Bartłomiej Danek
·
1 response
·
s3, aws, bash, postgresql
Pause and resume hot_standby replication on Postgres database
Cristóbal Castillo
·
0 responses
·
postgres, database, replication, postgresql
Advanced Rails Indexing: WHERE clause (postgresql)
Kurtis Rainbolt-Greene
·
2 responses
·
rails, activerecord, indexing, postgresql
PostgreSQL: Flatten hierarchy in one query
mroach_
·
0 responses
·
postgresql, pgsql, recursive cte, hierarchy
Reset heroku postgres database
Abraham
·
1 response
·
rails, heroku, rake, deploy
Rails rake tasks to dump & restore PostgreSQL databases
Nathan Hopkins
·
0 responses
·
ruby, rails, postgresql
Calculating Median in PostgreSQL
Gefei
·
0 responses
·
sql, aggregation, postgresql, median
Automated PostgreSQL install and configuration with PowerShell
Stefan Prodan
·
0 responses
·
powershell, postgresql
SQLZOO - Learn and practice SQL
Filly
·
0 responses
·
mysql, sql, oracle, databases
simple full text search using postgres on rails
Greg Osuri
·
2 responses
·
ruby, rails, activerecord, postgresql
Consider subqueries instead of joins
Hannes Georg
·
1 response
·
mysql, sql, postgresql