From the course: Database Foundations: Database Management
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create temporary tables
From the course: Database Foundations: Database Management
Create temporary tables
- [Narrator] It's possible for individual users to create their own temporary sets of data tables in a database. This can be helpful for gathering data for personal projects or analysis work or moving items to temporary staging tables for processing before finalizing rights to more permanent data tables. These temporary tables are not accessible by other users. They can only be read and written to by the user that created them. To see how this works, let's once again, create a new query window connected to the Postgres servers to tree database. Postgres uses the create temporary table command to well create a temporary table. Other than the inclusion of the temporary keyword the rest of the command is exactly the same as creating a standard permanent data table. We can create a temporary table here that's populated with data about all of the infused oil products by copying it out of the products table. I'll name this table, infused oils temp. Then we use our as keyword followed by the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.