# Using the `psql` commandline client and other tools


## List the networks. There should be a container running on the network `postgis_default`
```
docker network ls
```

> 2e2afc387fbb        postgis_default               bridge              local


## Connect to PostGIS using the `psql` client (from Docker):

```
docker run --net postgis_default -it --rm \
    --link postgis:postgis postgres psql -h postgis -U postgres -d gis
```

## Using a local client:
```
psql -h localhost -U postgres -d gis
```

## List Tables:

```
\dt
```

## Run SQL Queries:

```
-- Events created by ABC, in descending order of creation date:
SELECT county, quaternary, slope_type, bedrock_ty, land_use_c, creationda, creator
    FROM public."Landslide_Events"
    WHERE creator = 'ABC' ORDER BY creationda DESC;
```