TimJMartin · August 9, 2016 06:59
diff --git a/A Useful PostGIS queries and functions b/A Useful PostGIS queries and functions
 The following is a set of useful PostGIS queries and functions
diff --git a/Add primary key to existing b/Add primary key to existing
 ALTER TABLE test1 ADD COLUMN id SERIAL PRIMARY KEY;
diff --git a/Check_sequence.sql b/Check_sequence.sql
 -- Login to psql and run the following
 -- What is the result?
 SELECT MAX(id) FROM your_table;

 -- Then run...
 -- This should be higher than the last result.
 SELECT nextval('your_table_id_seq');

 -- If it's not higher... run this set the sequence last to your highest pid it. 
 -- (wise to run a quick pg_dump first...)
 SELECT setval('your_table_id_seq', (SELECT MAX(id) FROM your_table));
 -- if your tables might have no rows
 -- false means the set value will be returned by the next nextval() call    
 SELECT setval('your_table_id_seq', COALESCE((SELECT MAX(id)+1 FROM your_table), 1), false);
diff --git a/Edit existing geometry b/Edit existing geometry
 ALTER TABLE mytable 
   ALTER COLUMN geom 
   TYPE Geometry(Point, 32644) 
   USING ST_Transform(geom, 32644);
diff --git a/Listen and Notify Functions b/Listen and Notify Functions
 https://blog.andyet.com/2015/04/06/postgres-pubsub-with-json/
	-- Login to psql and run the following
	-- What is the result?
	SELECT MAX(id) FROM your_table;

	-- Then run...
	-- This should be higher than the last result.
	SELECT nextval('your_table_id_seq');

	-- If it's not higher... run this set the sequence last to your highest pid it.
	-- (wise to run a quick pg_dump first...)
	SELECT setval('your_table_id_seq', (SELECT MAX(id) FROM your_table));
	-- if your tables might have no rows
	-- false means the set value will be returned by the next nextval() call
	SELECT setval('your_table_id_seq', COALESCE((SELECT MAX(id)+1 FROM your_table), 1), false);