Sequence | Serial data types in Postgresql | Full Course | Source Code

Sequence and Serial data types: Postgresql Full Course | PSQL | Screencasts | #psql #postgresql

Homework:
Create a sequence called auction_logs which starts from 100 and has an increment of 50. Use it to log auction activity on a hypothetical Laptop on ebay (hint: insert in to ebay_auction table). Alter the sequence to increment by 60. At the end drop the sequence (table) and make sure it is not available in pg_sequences table.

This screencast will take deep dive at sequences and series in PostgreSQL/PSQL. Through the video, we explore all about sequences, series data type, sequence-related PostgreSQL system information tables, and also go through the source code in detail to understand how it all works behind the scene.

Thanks for watching, if you like what you saw, give the video a like, and don't forget to subscribe! It inspires me to keep going.

Contents:
00:00 Introduction
01:33 What is a Sequence
04:40 Create Sequence (and Numeric Ranges)
20:57 Alter Sequence
22:29 Drop Sequence
24:04 Sequence C Source Code
27:43 pg_sequences C Source Code
29:29 Serial Data Type
35:22 Serial functions and Source Code
44:46 pg_get_serial_sequence
46:05 Recap
48:13 Your Homework
49:18 Thank you

Important Links:

[EugeneBos]

First time see someone is reading source code of the tool they are teaching haha Props 🤜🏻

[kaasbaas]

Subscribed! Was great thanks, the documentation is not that extensive and stack overflow was 90% questions from 2010

[behruzisaev]

Thank you very much for the video!
Btw, how can we use the value of pg_get_serial_sequence('table', 'id') inside the ALTER SEQUENCE query?