PostgreSQL Tutorial for Beginners 15 - PostgreSQL UPDATE
In this post we will learn How to use UPDATEClause 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:
# \i ;
List tables and sequences in your current db:
# \d
Delete database:
# DROP DATABASE MYDB
Quit the cli:
# \q
a distribution-independent PostgreSQL installati ...
#ProgrammingKnowledge #PostgreSQL_CREATE_TABLE #Learning #PostgreSQL #Programming #Database #Clauses #Commands #Functions #Administration
20191204
S_feUwqoosw
1 view
112
28
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