From the course: PostgreSQL Essential Training

Unlock the full course today

Join today to access over 24,400 courses taught by industry experts.

Create a table with pgAdmin

Create a table with pgAdmin - PostgreSQL Tutorial

From the course: PostgreSQL Essential Training

Start my 1-month free trial Buy for my team

Create a table with pgAdmin

“

- [Instructor] Now that our Kinetica database has a couple of schemas, we can start adding tables into them. Right click on the manufacturing schema and point to Create, and then, come down and click on Table. I'll name this new table Products. In the dialogue, you have dropdowns to select the table's owner if you'd like to change it, as well as the schema that it's in. You could change it right there. The tablespace references the location on our hard drive where the files for this data table will get saved to. When we set up the Postgres server, we created a default location for these files, so you can either leave this blank or choose the PG default tablespace. Both of these will do exactly the same thing. The partitioned option will allow you to split the table across multiple physical files on your computer, which can be useful for data tables that are expected to become very large. By placing portions of the data on…

Contents