postgres: random useful things

Run sql statements from the command line, use the -c flag

psql your_db -c "update users set is_active = 'f';"

view raw postgres_sql_command.sql.sh hosted with ❤ by GitHub

create a random value

	select md5(random()::text)

view raw postgres.random_value.sql hosted with ❤ by GitHub

crazy updates using regexp_matches

	-- changes joe.smith@gmail.com -> joe.smith@qa.com
	update users set email = replace(replace(regexp_matches(email, '.*@')::varchar, '{', ''), '}', '') || 'qa.com';
	-- there must be a better way to get rid of the {} chars returned by regexp_matches

view raw postgres.regexp_matches.sql hosted with ❤ by GitHub