From the course: PostgreSQL Essential Training
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Organize tables with schemas - PostgreSQL Tutorial
From the course: PostgreSQL Essential Training
Organize tables with schemas
- [Instructor] When we dig into the tree pane to explore the contents of the Postgres server, you'll recall that the tables that we've created so far are underneath a collection of items called schemas. For instance, in the colors database, I'll expand that open, we'll find a collection for our schemas. Inside of there, we have the public schema. Then in that we have our tables collection, and finally we get to the colors table. Schemas are a way to organize and group objects in your database, so this table, the colors table is more specifically the colors table in the public schema. You can see that if you select the colors table and then click on the View Data button on the toolbar. The select query that's generated by PG admin includes the two-part name for the table that includes the schema public. This is called the table's qualified name when it includes both the schema and the table name separated by a period. As a…
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.
Contents
-
-
-
-
-
(Locked)
Organize tables with schemas6m 35s
-
(Locked)
Create a table with pgAdmin6m 57s
-
(Locked)
Link primary and foreign keys6m 38s
-
(Locked)
Enforce referential integrity on related records6m 24s
-
(Locked)
Challenge: Execute a command on the Postgres server55s
-
(Locked)
Solution: Execute a command on the Postgres server5m 19s
-
(Locked)
-
-
-
-