slabad

Download the pre-patched powerline symbols font file.

$ wget -c https://github.com/Lokaltog/powerline/raw/develop/font/PowerlineSymbols.otf

Open “Font Book” (Hit Cmd + Space to open spotlight and type Font Book).
Go to “File > Add Fonts” and open the PowerlineSymbols.otf file.
After the font is added, right click on “PowerlineSymbols” font and select “Validate Font”.
Now the font should be installed and ready to use.
If you are using iTerm, change the non-ascii font to PowerSymbols to start using the powerline fonts.

	--1. Create Tables:

	Create table Genres (
	Id int primary key
	, genre varchar(50))

	-- I would recommend making all your ids IDENTITY columns so those ids are generated automatically. I'm making the comment here but this would be true across the board.

	Create table Movies (
	id int primary key

	--for a cross db query on the same host
	--no hostname or password is needed.
	--the following script adds the extension,
	-- creates a server, maps the postgres user,
	-- and imports the foreign db into a new schema

	BEGIN;
	CREATE EXTENSION IF NOT EXISTS postgres_fdw;
	DROP SERVER IF EXISTS fdw_server CASCADE;

	DO
	$$
	BEGIN
	EXECUTE format('CREATE TABLE %I AS SELECT * FROM backup', 'backup_' \|\| to_char(CURRENT_DATE,'yyyy-mm-dd'));
	END;
	$$ LANGUAGE plpgsql;


	CREATE OR REPLACE FUNCTION fn_hello(v_table text)
	returns void


	WITH constants AS (
	-- define some constants for sizes of things
	-- for reference down the query and easy maintenance
	SELECT current_setting('block_size')::numeric AS bs, 23 AS hdr, 8 AS ma
	),
	no_stats AS (
	-- screen out table who have attributes
	-- which dont have stats, such as JSON
	SELECT table_schema, table_name,

	USE Master;
	GO
	SET NOCOUNT ON

	-- 1 - Variable declaration
	DECLARE @dbName sysname
	DECLARE @backupPath NVARCHAR(500)
	DECLARE @cmd NVARCHAR(500)
	DECLARE @fileList TABLE (backupFile NVARCHAR(255))
	DECLARE @lastFullBackup NVARCHAR(500)