Josef Zavisek jzavisek

## iterm2-solarized.md

      
              2 files
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                jzavisek
                / iterm2-solarized.md
            
            
              Created
              January 3, 2017 09:56
                — forked from kevin-smets/iterm2-solarized.md
            
              
                iTerm2 + Oh My Zsh + Solarized color scheme + Meslo powerline font (OS X / macOS)
              
          
## all-indexes.sql
-- List all existing indexes and include some useful info about them (incl. the index's definition)

SELECT
    schemaname AS schemaname,
    t.relname AS tablename,
    ix.relname AS indexname,
    regexp_replace(pg_get_indexdef(i.indexrelid), '^[^\(]*\((.*)\)$', '\1') AS columns,
    regexp_replace(pg_get_indexdef(i.indexrelid), '.* USING ([^ ]*) \(.*', '\1') AS algorithm,
    indisunique AS UNIQUE,
    indisprimary AS PRIMARY, indisvalid AS valid,
	-- List all existing indexes and include some useful info about them (incl. the index's definition)

	SELECT
	schemaname AS schemaname,
	t.relname AS tablename,
	ix.relname AS indexname,
	regexp_replace(pg_get_indexdef(i.indexrelid), '^[^\(]\((.)\)$', '\1') AS columns,
	regexp_replace(pg_get_indexdef(i.indexrelid), '.* USING ([^ ]) \(.', '\1') AS algorithm,
	indisunique AS UNIQUE,
	indisprimary AS PRIMARY, indisvalid AS valid,