课程: Supabase Essential Training

免费学习该课程！

今天就开通帐号，24,700 门业界名师课程任您挑！

Exploring PostgreSQL features

Exploring PostgreSQL features

课程: Supabase Essential Training

开始一个月试用 购买团队方案

Exploring PostgreSQL features

“

- [Instructor] Almost every database has at least one unique feature, and PostgreSQL is no exception. PostgreSQL has two major features you won't find in every database, schemas and extensions. First up, let's take a look at schemas. I'm here in the table editor of Supabase, and you'll notice that there is the purchases table. This is a table that I added previously and it is in the public schema. If I click this public schema, it will drop down and show several other schemas that are a part of Supabase. By default, Supabase will drop you in the public schema through the dashboard. This is what is directly available through the Supabase API to your application. Each schema within a PostgreSQL database can be accessed with the same credentials, and you can also write queries spanning these schemas. Now, you may be wondering why are all these schemas here in the first place? The schemas that are here, aside from public, are supporting the Supabase platform. So for instance, this…

内容