bigint update script

diff --git a/sql/update_bigint.sql b/sql/update_bigint.sql
new file mode 100644 (file)
index 0000000..9cc0fff
--- /dev/null
+++ b/sql/update_bigint.sql
@@ -0,0 +1,9 @@
+\a
+\t
+\o /tmp/bigintupdate.sql
+select 'alter table "'||relname||'" alter '||attname||' type bigint;' from pg_attribute join pg_class on 
+(attrelid = oid) where attname like '%place_id%' and attnum > 0 and relkind = 'r'::"char" and atttypid = 23 
+and not relname::text ~ '^.*_[0-9]+$' order by 'alter table "'||relname||'" alter '||attname||' type 
+bigint;';
+\o
+\i /tmp/bigintupdate.sql