课程: Supabase Essential Training

免费学习该课程!

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

Creating tables in the dashboard

Creating tables in the dashboard

- [Instructor] Postgres provides several built-in column types for database tables, and these can be selected through the Supabase Dashboard. I'm going to open up one of these tables that are already defined here in the public schema. So to do that, I'm going to select customers, and click these three dots, and hit Edit Table. So scrolling down to the columns, we've got many different types that are available here in this dropdown. There are many types here, but they can be broadly categorized in the following way. There are number column types, there are JSON fields, there are text fields, and then there are date and time fields, and then finally a Boolean field. Let's go over each of these categories of types. So first, we have integers of different sizes. You can do a two-byte, a four-byte, or an eight-byte integer. It just depends on how much data you want to be able to store here. You can also select a float. Floats come in four-byte and eight-byte varieties, and those allow you…

内容