Alexander Bukarev javajefe

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

	SELECT
	tc.constraint_name,
	tc.table_name,
	kcu.column_name,
	ccu.table_name AS foreign_table_name,
	ccu.column_name AS foreign_column_name,
	format('ALTER TABLE "%s" RENAME CONSTRAINT %s TO fk_%s_%s;',
	tc.table_name, tc.constraint_name, tc.table_name, kcu.column_name)
	FROM
	information_schema.table_constraints AS tc

	SELECT
	tc.constraint_name, tc.table_name, kcu.column_name,
	ccu.table_name AS foreign_table_name,
	ccu.column_name AS foreign_column_name
	FROM
	information_schema.table_constraints AS tc
	JOIN information_schema.key_column_usage AS kcu
	ON tc.constraint_name = kcu.constraint_name
	JOIN information_schema.constraint_column_usage AS ccu
	ON ccu.constraint_name = tc.constraint_name

	package se.wendt.statoil.mastercard;

	import java.util.ArrayList;
	import java.util.concurrent.CountDownLatch;

	import redis.clients.jedis.Jedis;
	import redis.clients.jedis.JedisPubSub;

	public class JedisTest {