We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
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.
postgresDate and Time Functions
This a small overview on the date and time functions available for Postgres
postgres , date , time , db , functions , operatorsCreating a View
This post goes through some steps and considerations into creating a view
postgres , console , database , postgres , viewImport 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 , csvExport 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 , jsonList Databases
The commands to list databases and tables within the postgresql command line
postgresExport database
The shortcut command to export the DB from the console
postgres , console , dbExport to CSV
The shortcut command to export a table into CSV
postgres , console , db , csvPostgres Querying
This post contains some postgres querying and examples
postgres , console , db , queryingAccent characters
Postgres comes with many default extensions and they have one for dealing with accent characters.
postgres , elixir , accentCase insensitive column
In Postgres, users can define case insensitive column by using the citext extension
postgres , elixir , ectoDelete specific rows
The shortcut command to delete specific rows from the console
postgres , console , db