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
On this page of the site you can watch the video online Creating Databases and Tables in PostgreSQL with a duration of hours minute second in good quality, which was uploaded by the user Prof. Obetz 23 March 2024, share the link with friends and acquaintances, this video has already been watched 232 times on youtube and it was liked by 3 viewers. Enjoy your viewing!
