PostgreSQL Tutorial for Beginners 11 - PostgreSQL - AND condition
In this post we will learn How to use SELECT with AND condition 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 ;
List tables and sequences in your current db:
# \d
Delete database:
# DROP DATABASE MYDB
Quit the cli:
# \q
a dis ...
#ProgrammingKnowledge #PostgreSQL_CREATE_TABLE #Learning #PostgreSQL #Programming #Database #Clauses #Commands #Functions #Administration
20191124
VGkggh60X4U
1 view
97
36
7 months ago 11:12:21 1
Build a Duolingo Clone With Nextjs, React, Drizzle, Stripe (2024)
7 months ago 02:37:26 1
Linux сервер для Django проекта (Nginx, gunicorn, PostgreSQL) + простой CI/CD 🔴 #008 Django СТРИМ
7 months ago 04:19:34 47
Learn PostgreSQL Tutorial - Full Course for Beginners
8 months ago 00:04:05 1
Laravel, InertiaJS, ReactJS & MariaDB (LIMR Stack) - Share Data