Other than the system tables, we can create many user-defined tables for our usage. Also, information about which tables are locked currently for updation if any query of retrieval is fired on that table is maintained in system tables. Other than this, the system tables also maintain the data about SQL and strategic parameters that decide how any operation will be executed and the main constraints to be taken care of while executing any command. These tables are used internally by the database to perform operations and store system variables, operators and functions. Whenever you create a new database in PostgreSQL, it contains many default tables, which are called the system tables. Whenever you work on the database, it is very common to retrieve the tables and their structure present in your database as it gives you a general idea of what are all the entities that are being stored in your database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |