# Postgres

connect to Postgres SQL shell

(generally you may find in location), /Applications/PostgreSQL 11/SQL Shell (psql).app

```
\h for help with SQL commands
```

```
\? for help with psql commands
```

```
\l -> this to list all databases.
```

```
\c db -> to connect with database caled db
```

```
\d -> to list all tables.
```

```
\dn -> list all schema
```

```
\dt lists tables for public schema. To show tables of all schemas use \dt *.* 
and for a particular schema use \dt schema_name.*
```

```
\q to quit
```

Copy from csv file to table:

```
COPY Emp(name, id) FROM '\tmp\test.csv' DELIMITER ',' HEADER ;
```