postgresql.txt（国外英文资料）.docVIP

postgresql.txt（国外英文资料） The definition of a table: For any relational database, tables are the most core and fundamental object unit of data storage. Lets start here. Create a table: The CREATE TABLE products ( Product_no integer, The name text, Price numeric ); Delete table: DROP TABLE products; Create a table with default values: The CREATE TABLE products ( Product_no integer, The name text, Price numeric DEFAULT 9.99 -- DEFAULT is the keyword, and then 9.99 is the DEFAULT value for field price. ); The CREATE TABLE products ( Product_no SERIAL, - the field of SERIAL type indicates that the fi