siedovolosyi/update country

Last active May 11, 2017 14:41

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/siedovolosyi/95433104dae9c678b3d99e881db50da9.js"></script>
Save siedovolosyi/95433104dae9c678b3d99e881db50da9 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

update country

DO $$DECLARE	tables CURSOR FOR			SELECT table_name			FROM information_schema.columns			WHERE column_name='country';	newName TEXT = 'al';BEGIN	FOR broken_table IN tables LOOP	 EXECUTE 'UPDATE '  || broken_table.table_name  || ' SET country = ''' || newName || '''';	END LOOP;END $$

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment