Postgresql Notes

Last updated on June 26, 2023

-- List databases
$> \l
-- Connect to a database
$> \c orendaa_development
-- Create extension citext
$> CREATE EXTENSION citext;
-- List users
$> \du

To use postgis extension

1. Add gem 'activerecord-postgis-adapter' in Gemfile
2. Do bundle install
3. Create a migration to add the PostGIS extension to your database.

   $> rails g migration AddPostgisExtensionToDatabase
   

4. Add enable_extension postgis

   class AddPostgisExtensionToDatabase < ActiveRecord::Migration[7.0]
     def change
    enable_extension 'postgis'
     end
   end
   

5. Run rails db:migrate

This is a sapling 🌱 in my digital garden 🏡.

Notes mentioning this note

There are no notes linking to this note.