Blogs about: Postgres
Featured Blog
MySQL vs. PostgreSQL—Which Database Is Better?
I’ve looked at the pros and cons of both Postgres and MySQL—the conclusion I come to: It depends on your preference. Both vendors develop powerful databases. Thier speed isn’t all that bad… more →
We Moved to clintonskakun.com
Postgres tips #1 - copying type
yogaboy3 wrote 2 weeks ago: A really nice feature of Postgres [1] that I’ve been using lately is copying types. When you … more →
Why I Haven't Switched to PostgreSQL
frickenate wrote 3 weeks ago: Over the years, I’ve always used MySQL for persistent data storage to back the website project … more →
postgres ERROR: role "username" does not exist
sakafi wrote 1 month ago: Issue 1 When I am trying to create Postgre DB using Cpanel, I get the following error: Error from po … more →
Postgres Workaround for "failed to find unique expression in subplan tlist"
fwhaslam wrote 1 month ago: I encountered this error while constructing an update to move subscriptions from one group to anothe … more →
backup-restore in Postgres (8.2)
felineinfinity wrote 1 month ago: For some reason, the ONLY way that copying the database in Postgres works for me is if I backup the … more →
PostGRES select and count unique day events
lin80h wrote 1 month ago: Problem: I wanted to have event table where i select rows by month. And i where searching way to cou … more →
Postgres SQL Commands
— 1 comment
coolmaddyworld wrote 1 month ago: I started using postgreSQL command line mode and then stop, again start and stop. So keep forgetting … more →
Introduction To PostgreSQL
Gopalasivam wrote 1 month ago: PostgreSQL is an object-relational database management system (ORDBMS). It is Free and Open Source S … more →
Using Scala to replace a Rake task
Jem wrote 2 months ago: At work we recently completed a task to generate a datafile of locations mapped to nearby locations. … more →
Find Unique Values in PostGres
lin80h wrote 2 months ago: From message board. Link … more →
Oracle 11gR2 Database: An Expert's Insider Insights
Integra Technology Consulting wrote 2 months ago: Integra’s Jason Buchanan, a 17-year veteran of the Oracle Database with over 60 11g RAC and 14 … more →
PostgreSQL Cascading: Updates and Deletes
— 1 comment
alexhochberger wrote 2 months ago: So something nice about a real database is cascading values, most commonly used to deletion, but you … more →
Postgres & Java
deshartman wrote 2 months ago: I’m looking into the PLJava package for Postgres. Looks interesting from what I have read alre … more →
PostgreSQL - linked libraries on OSX
yogaboy3 wrote 2 months ago: I just installed Postges 8.4.1 on OSX Tiger, and compared to the MySQL install it was a piece of cak … more →
Consultancy and skills development
wrightsolutions wrote 2 months ago: Consultancy relies in no small part in having a skill set which reflects what is hot in the IT marke … more →
Primary Keys in PostgreSQL shouldn't be a Mystery
— 2 comments
alexhochberger wrote 3 months ago: PostgreSQL has so much power, and people think it’s much harder to use. You can do just about … more →
PostgreSQL is Powerful, Confuses Newbies
alexhochberger wrote 3 months ago: Looking at the list of PostgreSQL blog entries, I saw this one, Add auto increment column in Postgre … more →
Table Auditing/History with triggers in Postgres, revised
armingroll wrote 3 months ago: There is already good documentation on this subject of course at the postgres site: http://developer … more →
Installing PlPython (Postgres 8.1 on Centos 4)
— 1 comment
writeonly wrote 3 months ago: I kept getting this sort of error from createlang (PG 8.1 on Centos 4 — from when dinosaurs wa … more →
