> For the complete documentation index, see [llms.txt](https://jairanjankumar.gitbook.io/cheatsheet/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jairanjankumar.gitbook.io/cheatsheet/postgres.md).

# 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 ;
```