Query Postgresql from Bash Command Line

2021-08-12 · 1 min read · postgresql db tricks ·

Share on:

1psql -c "<your_query_here>"

Example, to show tables list:

1psql -c "\dt+"

Posts in this Series

Ismael Casimpan Jr.

CompTIA Linux+/Security+ Certified IT Professional and perpetual learner.

Disclaimer

The opinions expressed on this site are my own personal opinions and do not represent my employer’s view in any way.

Posts in this series

Featured Posts

Git Rebase
Docker MySQL Backup to Local

Recent Posts

Install Python Module Directly
Python Virtualenv
Vagrant in Linux
Awk Variable Value from Bash
Save Separate Columns Into Separate Files using Awk
Swap Every Two Lines in Text File using Awk
Oneline AWK Two Decimal Filter
TravisCI for Hugo Build

Categories

DEVOPS 41 BOOKMARKS 7 WEB-DEVELOPMENT 3

Series

VERSION-CONTROL 19 DEBIAN-LINUX 12 ONELINER 6 DEBIAN-PHP 2 FRONTEND 2 LINUX 2 REDHAT-LINUX 2 REDHAT-PHP 2 BACKEND 1 DEBIAN-PPA 1 DEVELOPMENT 1 VIRTUALIZATION 1

Tags

DRUPAL 61 SSLCERT 36 MYSQL 35 MARIADB 34 PHP 33 GIT 32 ANSIBLE 31 TLSCERT 31 TROUBLESHOOTING 30 INSTALL 28 DOCKER 25 DRUSH 24 CONTAINER 19 DEB 18

All Tags

.HTACCESS1 4042 ACCESS3 ACL2 ACQUIA6 ADMIN3 AES1 AGGREGATION1 ANSIBLE31 APACHE9 ARRAY2 AUDIT1 AUTH1 AUTHENTICATE1 AUTHENTICATION3 AUTOMYSQLBACKUP3 AWK5 AXIOS1 BACKUP3 BACKUPS1 BAD2 BASH5 BASH-LINKS1 BASIC1 BEGINNERS1 BERRYSERVER1 BEST-PRACTICES2 BIND1 BLACKIST1 BLOCKED1 BLOCKINFILE1 BOM1 BRANCH2 BREW1 BROKEN1 BUILD1 BUNDLE1 CA1 CA-BUNDLE1 CACHE3 CACHING1 CANNOT-SEND1 CENTOS6 CENTOS72 CERT1 CERT-CHAIN2 CERT-CONVERSION1 CHAIN-ISSUE1 CHANGE3 CHARACTER-SET3 CHARSET3 CHECK-OS1 CHECKOUT1 CHERRY-PICK1 CI6 CIM1 CLI9 CLOUDFLARE1 CLUSTER2 COMMAND1 COMMITTER2 COMODO6 COMODO-CERT5 COMPOSER6 COMPRESSION2 COMPUTER2 CONDITIONAL1 CONFIG12 CONFIGURATION10 CONFIGURE4 CONTAINER19 CONTRIB1 CONVERSION1 CONVERT1 COPY1 COPY-FILE1 COUNT1 CREATE2 CREATE-DIRECTORY1 CREATE-FILE1 CREDENTIALS7 CREDENTIALS-FILE2 CRON1 CROSS-CHECK1 CSR10 CSV1 CURL6 D73 D88 DAEMON1 DATABASE7 DATABASES1 DB3 DB-BACKUP1 DEB18 DEBIAN11 DEBUGGING2 DEFFIE-HELLMAN1 DELAY1 DELETE2 DEPLOY1 DEPTH1 DETECTION1 DEVELOPER1 DEVTOOLS1 DIFF2 DIRECTORY1 DISK1 DJANGO4 DNS1 DOCKER25 DOCKER-ALTERNATIVE1 DOCKER-COMPOSE1 DOCKERCE1 DOCKERFILE2 DOCKERHUB2 DOKS1 DOMAIN1 DOMDOCUMENT1 DOTFILES1 DOWNLOAD1 DOWNTIME1 DRUPAL61 DRUPAL-ADMIN1 DRUPAL-SOLR1 DRUPAL71 DRUPAL91 DRUPALADMIN1 DRUSH24 DRUSH-ALIAS2 DUMP4 DYNAMIC-LIBRARY1 ELIMINATE1 EMAIL1 ENCRYPTION2 ENTITIES1 ENTITY1 ERROR18 EXAMPLE1 EXCLUDE1 EXTENDED-SUPPORT1 FACTS2 FAIL2BAN3 FAILURE3 FATAL1 FATAL-ERROR2 FEATURE1 FEATURES1 FILES2 FILESYSTEM2 FILTER1 FILTER-BRANCH1 FIREWALL5 FIREWALLD2 FORCED2 FTP1 GD1 GIT32 GITHUB2 GITHUB-API1 GITIGNORE1 GMAIL1 GO-LINKS1 GODOC1 GOLANG5 GOOGLE1 GOPATH1 GPG1 GRAPH1 GUIDE5 GZ1 GZ21 GZIP1 GZIP-COMPRESSION1 HARDCODED1 HARDCODED-DNS1 HARDENING2 HDMI-CEC1 HEADERS1 HEADLESS1 HELM2 HIDDEN1 HOLD1 HOSTING2 HOSTS1 HSTS2 HTACCESS2 HTTPS1 HUGO6 IGNORE1 IGNORED-PASSWORD1 IMAGE1 IMAGES2 IMPORT1 INCLUDE1 INDEX1 INFORMATION_SCHEMA1 INIT1 INNODB2 INSTALL28 INSTALLATION4 INTERFACE1 INTERNET1 INVENTORY1 IP1 IPTABLES1 JAIL1 JAVA82 JAVASCRIPT-LINKS1 JENKINS5 JENKINSCI5 JOIN1 JSON1 K8S8 KERNEL2 KEY2 KEY_VALUE1 KEYS4 KUBECTL4 KUBERNETES8 LANGUAGE1 LARAVEL2 LARGE-FILES1 LETSENCRYPT7 LICENSE1 LINKS8 LINUX18 LINUX-FILESYSTEM1 LIST1 LOCALE1 LOCATION1 LOG2 LOGGING1 LOGIN3 LOGS9 LOOP2 LOW-VOLTAGE1 MAC2 MAIL2 MAILGUN1 MAINTENANCE1 MANAGED-KUBERNETES1 MANUAL1 MARIADB34 MASTER1 MASTER-SLAVE1 MAX-UPLOAD-SIZE1 MCRYPT2 MD51 MEMCACHE2 MEMORY2 MERGE2 MIGRATE2 MIGRATION2 MODIFIED-FILES1 MODULE8 MODULES3 MORE-INFO1 MOUNT1 MSSQL1 MULTI-CONDITION1 MULTI-PHP1 MULTIDOMAIN1 MULTIPLE1 MYSQL35 MYSQL-SECURITY1 MYSQLDUMP4 NAMI1 NETLIFY1 NETWORK-SOLUTIONS1 NETWORK-SOLUTIONS-CERT1 NEWRELIC2 NGINX13 NO-PUSH1 NODEJS3 NODES1 NOT-FOUND1 ONELINE2 OOP1 OPTIMIZATION2 OUTPUT1 OVERRIDE1 OWN-DOMAIN1 PACKAGE15 PAGINATION1 PANTHEON.IO7 PARAMIKO1 PASSHPRASE1 PASSPHRASE1 PASSWORD1 PATCH1 PATHSPEC1 PERFECT-FORWARD-SECRECY1 PERFORMANCE2 PERL1 PERL-LINKS1 PERMISSION6 PERMISSION-DENIED1 PERMISSIONS1 PFS1 PHP33 PHP-CODING8 PHP-CONVERT1 PHP-CURL2 PHP-ERROR1 PHP-INI2 PHP-LINKS1 PHP-LOG1 PHP-MEMORY1 PHP-MODULE1 PHP-MONGODB1 PHP-NOT-INSTALLED1 PHP-SYNTAX1 PHP.-MODULE1 PHPINFO1 PID1 PIP1 PLAYBOOK4 PLUGIN2 POD1 PODMAN1 PORTS1 POSITIVE-SSL1 POSITIVE-WILDCARD1 POSITIVESSL1 POSTFIX5 POSTGRESQL8 POWERSHELL12 PPA1 PRIVATE-FILE1 PRIVATE-KEY5 PROCESS1 PROGRAMMING3 PROJECT-NAMI1 PROXY1 PROXYPASS1 PSQL1 PUBLIC-KEY3 PULL1 PULL-REQUEST1 PUTTY1 PVC1 PYTHON7 PYTHON-CODING2 PYTHON-LINKS1 PYTHON-MODULE1 PYTHONIC1 QEMU1 QUEUE2 RAILS1 RASPBERRYPI5 REACTJS2 REBASE1 REBOOT1 REDIRECT3 REDIRECTS1 REGENERATE1 REGEX1 REGISTRY1 REINDEX1 REMI1 REMOTE5 REMOVE2 RENEW1 REPLICATION1 REPO2 REPORTS1 RESET1 RESTART1 RESTORE4 RETRIEVAL1 REVERT2 RICH-RULES1 ROOT3 ROOT-ACCOUNT1 RPM1 RR1 RSYNC4 RUBY6 RUBY-LINKS1 RUBY-ON-RAILS6 RVM2 SAN2 SAVE-SPACE1 SCRIPTING1 SEARCH1 SECURE1 SECURITY2 SELF-SIGNED-CERT1 SERVER2 SESSION1 SETTINGS7 SETUP2 SHELL2 SIZES1 SKELETON1 SLAVE2 SLOW1 SLOW-QUERY1 SMTP1 SOCKET-ERROR1 SOLR6 SOLR-CORE4 SOLR-REINDEX1 SPECIFIC-IP1 SQL1 SQLITE2 SSH13 SSH-KEY1 SSL2 SSL-BUNDLE1 SSLCERT36 SSLLABS1 SSO1 STAGE_FILE_PROXY1 STARTER1 STATIC1 STATIC-FILES1 STATUS2 STICKY-BIT1 STRING1 SUBMODULES2 SUDO1 SWAP1 SYMFONY1 SYNC1 SYSLOG1 TABLE5 TABLES3 TAG1 TAGCLOUD1 TAGS3 TEMPFILE1 TERMINUS1 TEST-MAIL1 TEXT-PROCESSING3 THEME1 TIMING1 TITLE1 TLSCERT31 TOOLS1 TRAVISCI1 TRICKS2 TROUBLESHOOT3 TROUBLESHOOTING30 TRUNCATE2 TUNING1 TV1 TWEAKS1 TXPOWER-ERROR1 UBUNTU12 UBUNTU-SNAP1 UFW2 UI-UX1 ULI2 UNARCHIVE1 UNDEFINED1 UNENCRYPT1 UNINSTALL1 UNIX2DOS1 UNSUPPORTED1 UPDATE2 UPDATES2 UPGRADE6 UPGRADES1 URL-CHANGE1 USB1 USB-DEVICES1 USER5 USERNAME1 UTF81 UUID1 VAGRANT1 VARIABLE2 VARIABLE-ASSIGNMENT1 VARNISH3 VAULT1 VCGENCMD1 VERIFICATION1 VERSION2 VERSION-CONTROL13 VIRTUAL-ENV1 VIRTUALHOST1 WEB-DEV4 WEBDEV-LINKS1 WEBDEV-TROUBLESHOOTING1 WEBSERVER18 WEBUI1 WHITELISTING1 WILDCARD1 WILDCARD-MULTIDOMAIN1 WINDOWS7 WIRELESS-INTERFACE1 WORDPRESS8 WORDPRESS-MSSQL1 WP-CLI3 WP-CONFIG1 WP_CLI2 WSL4 WSL-LINKS1 ZIP1

[A~Z][0~9]

Copyright 2018- IT QUICKTASKS. All Rights Reserved