Posts tagged ‘postgres’

Postgres query plan viewer

This will draw postgres query plans (from EXPLAIN and friends) in a form which may well be easier for you to parse.

http://www.dbplanview.com/

Advertisements

September 23, 2010 at 5:30 pm Leave a comment

Postgres sql basic querying based on datetime

For the benefit of google (and me when I’m using google)

In postgres and probably most other SQLs the following

SELECT * FROM table where creation_date > timestamp 'now' - interval '2 hours';

finds all records that were created in the last 2 hours.

See also:
http://www.postgresql.org/docs/8.0/static/datatype-datetime.html

March 11, 2010 at 9:29 pm Leave a comment


October 2017
M T W T F S S
« Nov    
 1
2345678
9101112131415
16171819202122
23242526272829
3031