Bash script

#!/bin/bash
echo Hello World!

Bash "=~" example

$ [[ 45 =~ [0-9]+ ]] && echo "45 contains digits"
45 contains digits

$ [[ "hello" =~ [0-9]+ ]] && echo "hello doesnt contains digits"
$ [[ "hello" =~ [a-z]+ ]] && echo "hello contains alphabets"
hello contains alphabets

Source: stackoverflow.com

Linux bash scripts tutorial

$ which bash

Source: linuxconfig.org

Bash script

# The bash function below utilizes the CLI tool psql to vacuum analyze tables
# in a single schema which can be identified by either passing the name of
# the schema as the first parameter to the function
# or setting the environment variable PG_SCHEMA:
#

vacuum_analyze_schema() {
    # vacuum analyze only the tables in the specified schema

    # postgres info can be supplied by either passing it as parameters to this
    # function, setting environment variables or a combination of the two
    local pg_schema="${1:-${PG_SCHEMA}}"
    local pg_db="${2:-${PG_DB}}"
    local pg_user="${3:-${PG_USER}}"
    local pg_host="${4:-${PG_HOST}}"

    echo "Vacuuming schema \`${pg_schema}\`:"

    # extract schema table names from psql output and put them in a bash array
    local psql_tbls="\dt ${pg_schema}.*"
    local sed_str="s/${pg_schema}\s+\|\s+(\w+)\s+\|.*/\1/p"
    local table_names=$( echo "${psql_tbls}" | psql -d "${pg_db}" -U "${pg_user}" -h "${pg_host}"  | sed -nr "${sed_str}" )
    local tables_array=( $( echo "${table_names}" | tr '\n' ' ' ) )

    # loop through the table names creating and executing a vacuum
    # command for each one
    for t in "${tables_array[@]}"; do
        echo "doing table \`${t}\`..."
        psql -d "${pg_db}" -U "${pg_user}" -h "${pg_host}" \
            -c "VACUUM (ANALYZE) ${pg_schema}.${t};"
    done
}

Source: stackoverflow.com

Similar codes

3 votes99 views1 answer
Gyp ERR! stack Error: not found: make
Shell/Bash
0 vote97 views1 answer
Height not divisible by 2 (3308x1975) Error initializing output stream 0:0 -- Error while opening encoder for output stream #0:0 - maybe incorrect parameters such as bit_rate, rate, width or height
Shell/Bash
0 vote102 views1 answer
C compile using gcc considering warnings as errors
Shell/Bash
2 votes106 views2 answers
The command
Shell/Bash
0 vote102 views1 answer
Linux write
Shell/Bash
2 votes155 views1 answer
Raspberry pi wifi setup wpa_supplicant
Shell/Bash
15 votes129 views3 answers
Ionic capacitor v3 run android livereload
Shell/Bash
6 votes95 views1 answer
How to open a .conf file in terminal
Shell/Bash
1 vote105 views1 answer
Using wget with a proxy
Shell/Bash
8 votes100 views2 answers
Bash script: replace . with :
Shell/Bash