![]() ![]() INSERT INTO products(product_name, retail_price) VALUES ('RIBENA JUICE', 7.70) INSERT INTO products(product_name, retail_price) VALUES ('HP WIRELESS MOUSE', 25.50) INSERT INTO products(product_name, retail_price) VALUES ('FRUITWORLD WATERMELON', 3.25) INSERT INTO products(product_name, retail_price) VALUES ('WIRELESS USB DONGLE FOR DELL', 4.50) INSERT INTO products(product_name, retail_price) VALUES ('LOGITECH WIRELESS MOUSE', 16.50) INSERT INTO products(product_name, retail_price) VALUES ('RIB MEAT', 4.89) INSERT INTO products(product_name, retail_price) VALUES ('DELL WIRELESS MOUSE', 25.50) e_commerce=# INSERT INTO products(product_name, retail_price) VALUES ('BUTTERFLY DECORATIONS', 35.20) Insert sample data into the products table. Use the SERIAL keyword on the PRIMARY KEY column to allow the PostgreSQL server to assign new product_ids automatically for new records. This table stores the products' details including the unique product_id, product_name, and retail_price. You are now connected to database "e_commerce" as user "postgres".Ĭreate a products table. $ sudo -u postgres psqlĮnter the password and press ENTER to proceed.Ĭreate a sample e_commerce database. Log in to the PostgreSQL server as the postgres user. SSH to your Linux server as a non-root sudo user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |