PostgreSQL

Error converting content: marked is not a function

- 101 Info On Mac
- Postgres works pretty hard to make itself usable right out of the box without you having to do anything. By default, it automatically creates the user `postgres`
- ```bash
	  > psql postgres
	  ```
  - ![image.png](../assets/image_1703689938510_0.png){:height 200, :width 726}
- While it is certainly ***convenient*** that Postgres sets up a set of default users for you, it is a **very bad idea** to use them for anything except local development, because they are very widely known and more importantly, they are **super user** accounts—they can do anything, including delete databases.
- Commands
- `\du` - list all users
- to show databases : `\l`
- to connect to db: `\c`
- to show tables : `\dt` `\dt *`
- to show data in table x : `SELECT * FROM "x";`
- to exit : `\q`
	-