kachalovsky

maxclaus / postgres-dblink.sql

Created April 11, 2016 11:36

Example using dblink to execute a SELECT query between different databases. (PG 9.4)

	-- enable dblink support
	CREATE EXTENSION dblink;

	-- create the connection
	SELECT dblink_connect('myconn', 'dbname=tracking-service');

	-- then use the connection
	SELECT "oauthId"
	FROM "56_profile" local
	INNER JOIN dblink('myconn','SELECT DISTINCT user_id FROM "event"')

andrewconlan / Swipe.swift

Last active February 26, 2018 15:28

Fix Broken Swipe to Go Back With Hidden Navigation Bar

	if let navigationController = navigationController, interactivePopGestureRecognizer = navigationController.interactivePopGestureRecognizer {
	navigationController.setNavigationBarHidden(true, animated: true)
	interactivePopGestureRecognizer.delegate = self
	}