| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
Before we can setup PostGIS we need to have a local version of Postgresql installed and running. The most effecient way to do this is to download and install Postgres.app.
Once Postgres.app is installed in your computers /Applications directory. Open the Terminal and enter the following two commands
psql -d DATABASE_NAME -f /Applications/Postgres.app/Contents/Versions/9.3/share/postgresql/contrib/postgis-2.1/postgis.sql
| function onOpen() { | |
| var ui = DocumentApp.getUi(); | |
| ui.createMenu('Convert to .RST') | |
| .addItem('Convert to .RST and email me the result', 'ConvertToRestructuredText') | |
| .addToUi(); | |
| } | |
| // Adopted from https://github.com/mangini/gdocs2md by Renato Mangini | |
| // License: Apache License Version 2.0 | |
| String.prototype.repeat = String.prototype.repeat || function(num) { |