Author: Website Admin

Initializing the repository Initializing from a remote Git repository: Initializing from inside Git repository Initializing a new repository based on existing Git repository Bookmark (Branch) List bookmarks Tracking remote a remote bookmark Working with the repository Making a new revision on top of current working directory Making a new revision on top of remote bookmark…

Select from table Select from another query Save query to a variable, and use that variable with another select Using the results of another query as a condition

Broadcast message on all ports:

Connect to database: Turn on headers (default: off) Select mode (default: list) Run your query

Create user: Create a database: Grant user to database: Grant user to schema: Configure the server: Configure server access: Restart posgresql:

Connect to psql via console: Description Command List database \list \l List database with extra information \list+ \l+ Connect to a database \connect <database-name> <username> \c <database-name> <username> List tables \dt Describe a table \d Describe a table with extra information \d+ List schemas \dn List user and roles \du List functions \df List views…

References:

Swap alt with gui: List all capabilities for ctrl and caps key: Add the keyboard swap:

Insert from other file Insert command result Output to external command. If you do not define the range, then by default, it will use all lines (1, $) in the file as an input for that command. Running external command