Summary
The chapter provided a guide on updating data in databases with the UPDATE statement, transforming data using PostgreSQL functions, creating user-defined functions with the CREATE FUNCTION statement, and changing table definitions with the ALTER statement. With this knowledge, you will be able to manipulate existing data and existing table structure to adapt to the changes in the real world. You will also be able to apply complex transformations with either system functions or your own functions.
At this point, you have learned how to work on each table within the CRUD lifecycle. You can create and drop the tables, insert or copy data, transform and update data, and alter the table structure, against a single table. Starting from the next chapter, you will look at the interactions between tables, as well as further aggregation from the raw tables.
Join our community on Discord
Join our community’s Discord space for discussions with the authors and other...
