PostgreSQL Tutorial for Beginners 23 - PostgreSQL LIKE Clause

In this post we will learn How to use PostgreSQL LIKE Clause in PostgreSQL. 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:
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 ★★★

★★★ Online Courses to learn ★★★

★★★ Follow ★★★

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!

[renrenofficial]

Sir do you have tutorial for parallel programming codes using java?