gullevek

# Final file has moved into a main GIT:
# https://github.com/gullevek/scripts/blob/master/screen/screen_init.sh
# This file below will no longer be updated.

#!/bin/bash

# AUTHOR: Clemens Schwaighofer
# DATE: 2015/8/4
# DESC: inits a screen with shells (sets titles) and runs command in those shells
#       reads all data from a config file

gullevek

package Progress;

# AUTHOR: Clemens Schwaighofer
# DATE CREATED: 2009/6/16
# DESCRIPTION: progress percent class

# METHODS
# * init
# my $prg = Progress->new();
#   will init a new progress class in the var $prg

gullevek

WITH btree_index_atts AS (
    SELECT nspname, relname, reltuples, relpages, indrelid, relam,
        regexp_split_to_table(indkey::text, ' ')::smallint AS attnum,
        indexrelid as index_oid
    FROM pg_index
    JOIN pg_class ON pg_class.oid=pg_index.indexrelid
    JOIN pg_namespace ON pg_namespace.oid = pg_class.relnamespace
    JOIN pg_am ON pg_class.relam = pg_am.oid
    WHERE pg_am.amname = 'btree'
    ),