Win OS – File Explorer – “Open Command Window Here”

Background A good friend is to trying to following instructions, but running into head wind. Issue The Instructions read :- Launch File Explorer. Navigate to a specific folder Right click on that folder and from the dropdown menu, select "Open command window here" Image Explanation In our case "Open Command Window here" does not appear. … Continue reading Win OS – File Explorer – “Open Command Window Here”

PostgreSQL – Table Value Constructor

Background Part of a DBA's workload is to engage the Developers Community and make sure that SQL Changes are streamline and easy to review and deploy. Adding Data Recently we needed to add about one hundred records to a single table. Table Value Constructor Thankfully SQL 92 thought quite a bit ahead and recommends support … Continue reading PostgreSQL – Table Value Constructor

Ephrat Livni :- Justice Brett Kavanaugh On “Constitutional right to unanimous jury” and Intent

    Link The Supreme Court heard arguments Monday on the constitutionality of a Louisiana law that allows criminal convictions based on jury verdicts that aren’t unanimous. Justice Brett Kavanaugh pointed out that the Louisiana law had racist roots. He noted that there were two “practical reasons” to overrule the precedent the state relied on. … Continue reading Ephrat Livni :- Justice Brett Kavanaugh On “Constitutional right to unanimous jury” and Intent

Melinda Henneberger :- Vatican Says Jews’ Wait for Messiah Is Validated by the Old Testament

Background This article is almost twenty years old. At the rate at which new articles are being published, twenty years is almost what a century was a few decades ago.   Article Melinda Henneberger, New York Times Link The Vatican has issued what some Jewish scholars are calling an important document that explicitly says, ''The … Continue reading Melinda Henneberger :- Vatican Says Jews’ Wait for Messiah Is Validated by the Old Testament

Witchcraft & Governance

Background This is a difficult subject material. But, each one of us encounter problem areas in our lives.   Videos Pastor John A. Kilpatrick Witches cast spells against 'wicked' Trump Profile Alabama pastor John A. Kilpatrick calls for prayer against witchcraft, for Trump Videos Video #1 Channel :- AL.com Published on :- 2018-August-22nd Link  Fox … Continue reading Witchcraft & Governance

PostgreSQL – List Databases

Background Let us list databases. Code Outline Access pg_catalog.pg_database pg_catalog.pg_tablespace Default Table space Name pg_database.dattablespace = pg_tablespace.oid pg_catalog.pg_authid Authorizer pg_database.datdba = pg_authid.oid pg_catalog.pg_encoding_to_char Encoding pg_catalog.pg_encoding_to_char(pg_database.encoding ) pg_catalog.pg_stat_file Database Creation Date pg_catalog.pg_stat_file ( 'base' ||'/' ||pg_database.oid ||'/' ||'PG_VERSION' ) SQL Output References PostgreSQL Functions and Operators System Administrative Functions Link

PostgreSQL :- Permit Network Access

Background It is time to allow network access to our PostgreSQL server. Outline Server Configuration ( Files ) postgresql.conf IP Interface ( Listen address ) Port Number Default :- 5432 pg_hba.conf ( PostgreSQL Client Authentication Configuration File ) Rules Firewall Host Firewall Network Firewall Reload Configuration pg_hba configuration Either of these options Command Line Shell … Continue reading PostgreSQL :- Permit Network Access