Postgres

Remove postgresql ubuntu

sudo apt-get --purge remove postgresql
sudo apt-get purge postgresql*
sudo apt-get --purge remove postgresql postgresql-doc postgresql-common

Postgres

Fun fact: "Postgres" has exactly as many characters as "Database"
Check for yourself!
Postgres --> 8 chars!
Database --> 8 chars!

Postgres

SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1, value2, ...);

PostgreSQL

sudo mkdir -p /etc/paths.d &&
echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp

Source: postgresapp.com

Postgresql

# 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

Postgre

PostgreSQL: The World's Most Advanced Open Source Relational Database

Similar codes

1 vote138 views2 answers
Mysql show views
SQL
2 votes138 views2 answers
Mysql all columns
SQL
0 vote153 views1 answer
C# execute transact sql
SQL
1 vote146 views1 answer
Date_part mysql
SQL
0 vote142 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote160 views1 answer
Mysql get only the field names in a table
SQL
0 vote159 views1 answer
Sql order by except one row
SQL
13 votes199 views3 answers
Mysqldump structure only
SQL
11 votes139 views5 answers
How to install sqlite3 python
SQL
23 votes126 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL