Posts that contain postgres

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.


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


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