View hs_2json.sql
create or replace function hs_2json(hs hstore) returns text language sql | |
as $f$ | |
select '{' || array_to_string(array_agg( | |
'"' || regexp_replace(key,E'[\\"]',E'\\\&','g') || '":' || | |
case | |
when value is null then 'null' | |
when value ~ '^(true|false|(-?(0|[1-9]\d*)(\.\d+)?([eE][+-]?\d+)?))$' then value | |
else '"' || regexp_replace(value,E'[\\"]',E'\\\&','g') || '"' | |
end |
View ubuntu-11.10-gems.erb
bash -c ' | |
<% if knife_config[:bootstrap_proxy] -%> | |
( | |
cat <<'EOP' | |
<%= "proxy = #{knife_config[:bootstrap_proxy]}" %> | |
EOP | |
) > ~/.curlrc | |
<% end -%> | |
if [ ! -f /usr/bin/chef-client ]; then |
View mk_postgis_template.sh
# Set postgis-1.5 path. | |
$ POSTGIS_SQL_PATH=`pg_config --sharedir`/contrib/postgis-1.5 | |
# Creating the template spatial database | |
$ createdb -E UTF8 -T template0 template_postgis | |
# and add PLPGSQL language support. | |
$ createlang -d template_postgis plpgsql | |
# Loading the PostGIS SQL routines. | |
$ psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis.sql |
View gdal.rb
require 'formula' | |
class Gdal <Formula | |
url 'http://download.osgeo.org/gdal/gdal-1.7.2.tar.gz' | |
homepage 'http://www.gdal.org/' | |
md5 '05351f8cb61761ae579667e24a297fe6' | |
def options | |
[ | |
['--with-pg', "Include PostgreSQL support."], |