Database Reference
In-Depth Information
INSERT INTO fruits_in_stock(name,in_stock)
Then, we check that stock (this is using the expanded display):
postgres=# \x
Expanded display is on.
postgres=# SELECT * FROM fruits_in_stock;
-[ RECORD 1 ]----
name | APPLE
in_stock | 500
reserved | 0
-[ RECORD 2 ]----
name | ORANGE
in_stock | 500
reserved | 0
Next, let's make an offer of
100
apples to Bob:
postgres=# INSERT INTO
fruit_offer(recipient_name,fruit_name,offered_amount)
VALUES('Bob','APPLE',100);
INSERT 0 1
postgres=# SELECT * FROM fruit_offer;
-[ RECORD 1 ]--+---------------------------
offer_id | 1
recipient_name | Bob
offer_date | 2013-01-25 15:21:15.281579
fruit_name | APPLE
offered_amount | 100
postgres=# SELECT * FROM fruits_in_stock;
-[ RECORD 1 ]----
name | ORANGE
in_stock | 500
reserved | 0
-[ RECORD 2 ]----
