Postgres not running with Homebrew

If you have the latest Apple M1 computer and you used homebrew to install postgres this quick tutorial might help you out.

postgres

---

Date and Time Functions

This a small overview on the date and time functions available for Postgres

postgres , date , time , db , functions , operators

---

Creating a View

This post goes through some steps and considerations into creating a view

postgres , console , database , postgres , view

---

Import CSV

This blog post shows how you create a temporary table in Postgres that you then can import into the database

postgres , console , csv , import , csv

---

Export to JSON

I need to export a tables data into JSON for prototyping and experiment purposes. This blog post is just for reminding me on the commands.

postgres , console , json

---

List Databases

The commands to list databases and tables within the postgresql command line

postgres

---

Export database

The shortcut command to export the DB from the console

postgres , console , db

---

Export to CSV

The shortcut command to export a table into CSV

postgres , console , db , csv

---

Postgres Querying

This post contains some postgres querying and examples

postgres , console , db , querying

---

Accent characters

Postgres comes with many default extensions and they have one for dealing with accent characters.

postgres , elixir , accent

---

Case insensitive column

In Postgres, users can define case insensitive column by using the citext extension

postgres , elixir , ecto

---

Delete specific rows

The shortcut command to delete specific rows from the console

postgres , console , db

---