Creating Databases and Tables in PostgreSQL
In this video, we explore how to perform common DDL operations in a Postgres database. We cover how to log into postgres on the command line with psql, how to create users and databases, and how to create, modify, and drop tables from our database. We also look at how we can perform these same operations using the pg package in NodeJS.
0:00 Introduction
0:50 Running PSQL
2:27 Creating Users and Databases
4:26 Building Tables and Examining Relations
7:25 Connecting to Postgres from NodeJS
11:10 Executing Queries with PG
13:52 Re-running CREATE Statements and DROP
17:15 Verifying Tables Were Created
20:35 Column Constraints (NOT NULL, UNIQUE...)
24:06 Primary Keys and References
29:02 Viewing Foreign Key Constraints in Action
30:39 ALTERing Existing Tables
32:41 Summary
En esta página del sitio puede ver el video en línea Creating Databases and Tables in PostgreSQL de Duración hora minuto segunda en buena calidad , que subió el usuario Prof. Obetz 23 marzo 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 232 veces y le gustó 3 a los espectadores. Disfruta viendo!
