In this post we will learn How to Create a SELECT Query in PostgreSQL (PostgreSQL Create Database). psql is the standard PostgreSQL application to work with databases Common psql Meta-commands:
\a: toggle output format (aligned/unaligned)
\c name: connect to a database name
\copy table: copy a table to/from a file
\d : list all tables (display)
\d table: show information about a table
\e: edit the query buffer
\g: execute the query buffer (go)
\h command: display help on command
\i name: read name into query buffer (input)
List all databases:
# \l
Create a new database:
# CREATE DATABASE MYDB;
Use a database:
# \connect MYDB;
Run database schema:
# \i filepath.txt;
List tables and sequences in your current db:
# \d
Delete database:
# DROP DATABASE MYDB
Quit the cli:
# \q
a distribution-independent PostgreSQL installation.
the popular open-source PostgreSQL administration tool, pgAdmin.
the StackBuilder package manager (used to download and install drivers, tools
and applications to complement your PostgreSQL installation).
The sections that follow provide information about using the PostgreSQL 9.6/ PostgreSQL 10 installer:
How to satisfy hardware requirements and software prerequisites before installing
PostgreSQL.
Step-by-step instructions explaining the installation options available with the
setup wizard.
How to use Stack Builder to install modules that provide enhanced functionality
for PostgreSQL 9.6/ PostgreSQL 10.
#ProgrammingKnowledge #PostgreSQL
★★★Top Online Courses From ProgrammingKnowledge ★★★
Python Programming Course ➡️ ⚫️
Java Programming Course ➡️ ⚫️
Bash Shell Scripting Course ➡️ ⚫️
Linux Command Line Tutorials ➡️ ⚫️
C Programming Course ➡️ ⚫️
C++ Programming Course ➡️ ⚫️
PHP Programming Course ➡️ ⚫️
Android Development Course ➡️ ⚫️
C# Programming Course ➡️ ⚫️
JavaFx Programming Course ➡️ ⚫️
NodeJs Programming Course ➡️ ⚫️
Jenkins Course For Developers and DevOps ➡️ ⚫️
Scala Programming Tutorial Course ➡️ ⚫️
Bootstrap Responsive Web Design Tutorial ➡️ ⚫️
MongoDB Tutorial Course ➡️ ⚫️
QT C++ GUI Tutorial For Beginners ➡️
★★★ Online Courses to learn ★★★
Get 2 FREE Months of Unlimited Classes from skillshare -
Data Science - |
Machine Learning - |
Artificial Intelligence - |
MERN Stack E-Degree Program - |
DevOps E-degree - |
Data Analytics with R - |
AWS Certification Training - |
Projects in Java - |
Machine Learning With TensorFlow - |
Angular 8 - Complete Essential Guide -
Kotlin Android Development Masterclass -
Learn iOS Programming Building Advance Projects -
★★★ Follow ★★★
My Website -
DISCLAIMER: This video and description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. This help support the channel and allows us to continue to make videos like this. Thank you for the support!
0 Comments