Skip to content

Commit d78f058

Browse files
committed
README: how to create test data.
1 parent 70871b2 commit d78f058

1 file changed

Lines changed: 21 additions & 0 deletions

File tree

‎README.md‎

Lines changed: 21 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -6,6 +6,27 @@ This is a basic, but complete, example of how to connect to Postgres, perform a
66

77
## Using
88

9+
Use `psql` to create the `weather` table and insert a few rows.
10+
11+
```
12+
CREATE TABLE weather (
13+
city varchar(80),
14+
temp_lo int, -- low temperature
15+
temp_hi int, -- high temperature
16+
prcp real, -- precipitation
17+
date date
18+
);
19+
20+
INSERT INTO weather
21+
VALUES ('San Francisco', 46, 50, 0.25, '1994-11-27');
22+
23+
INSERT INTO weather (city, temp_lo, temp_hi, prcp, date)
24+
VALUES ('San Francisco', 43, 57, 0.0, '1994-11-29');
25+
26+
INSERT INTO weather (date, city, temp_hi, temp_lo)
27+
VALUES ('1994-11-29', 'Hayward', 54, 37);
28+
```
29+
930
Set the following properties in `main.swift` to values appropriate for your environment:
1031

1132
- `configuration.host`

0 commit comments

Comments
 (0)