User contributions
From PostgreSQL wiki
(Latest | Earliest) View (newer 50) (older 50) (20 | 50 | 100 | 250 | 500)
- 17:51, 22 November 2012 (hist) (diff) Using EXPLAIN (Web site no longer exists.)
- 21:58, 28 December 2011 (hist) (diff) N Pg gethostname (Created page with "{{SnippetInfo|C function to get server hostname |version=9.0+|lang=C|category=Library}} Here is a compilable C function to get the server hostname. Tested with CentOS 5 x86_64,…")
- 17:32, 5 January 2011 (hist) (diff) PgBouncer (→Downloads)
- 16:49, 8 December 2010 (hist) (diff) GeoIP index
- 16:47, 8 December 2010 (hist) (diff) GeoIP index (New page: {{SnippetInfo|Spatial index on GeoIP data to speed up fetches|lang=SQL|category=Library|depends=Nothing}} If your are using PostgreSQL + ip2location (or MaxMind), creating the following ...)
- 22:28, 2 December 2010 (hist) (diff) Search public functions (top)
- 22:25, 2 December 2010 (hist) (diff) Distance in km (New page: {{SnippetInfo|Distance between 2 points|lang=PL/Perlu|category=Library}} To get the distance between two points (lat1, long1, lat2, long2), and accounting for the curvature of the Earth. ...) (top)
- 00:28, 29 November 2010 (hist) (diff) Search public functions
- 00:14, 29 November 2010 (hist) (diff) Audit trigger
- 00:09, 29 November 2010 (hist) (diff) Search public functions
- 00:08, 29 November 2010 (hist) (diff) Audit trigger
- 23:58, 28 November 2010 (hist) (diff) Audit trigger (New page: {{SnippetInfo|Generic audit trigger function |version=8.4+|lang=PL/pgSQL|category=Library}} Here is an example of a generic trigger function used for auditing changes to tables, and optio...)
- 14:40, 20 September 2010 (hist) (diff) Round time
- 23:53, 17 September 2010 (hist) (diff) m Round time
- 23:39, 17 September 2010 (hist) (diff) m Search public functions
- 23:38, 17 September 2010 (hist) (diff) Round time (New page: {{SnippetInfo|Rounds a timestamp to the nearest 5 minute mark|version=8.2|lang=PL/pgSQL|category=Library}} ''original code by brick'' Round a timestamp to the nearest 5 minute mark. If f...)
- 21:48, 17 September 2010 (hist) (diff) Search public functions
- 21:40, 17 September 2010 (hist) (diff) m Search public functions
- 18:18, 17 September 2010 (hist) (diff) Search public functions (New page: {{SnippetInfo|search_public_functions|version=8.4|lang=PL/pgSQL|category=Library}} <source lang="plsql"> -- load as superuser create or replace function search_public_functions(p_search_s...)
(Latest | Earliest) View (newer 50) (older 50) (20 | 50 | 100 | 250 | 500)
