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 – Aug 29 2021

Date and Time Functions

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

postgres, date, time, db, functions, operators – Apr 05 2019

Creating a View

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

postgres, console, database, postgres, view – Aug 27 2018

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 – Aug 27 2018

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 – Aug 27 2018

List Databases

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

postgres – Aug 27 2018

Export database

The shortcut command to export the DB from the console

postgres, console, db – Aug 26 2018

Export to CSV

The shortcut command to export a table into CSV

postgres, console, db, csv – Aug 26 2018

Postgres Querying

This post contains some postgres querying and examples

postgres, console, db, querying – Aug 26 2018

Accent characters

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

postgres, elixir, accent – Aug 25 2018

Case insensitive column

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

postgres, elixir, ecto – Aug 25 2018

Delete specific rows

The shortcut command to delete specific rows from the console

postgres, console, db – Aug 25 2018