Search for a command to run...
Articles tagged with #postgresql
PostgreSQL Upgrade and Database Restoration Guide To support the pgvector gem, I upgraded my local Postgres.app from v13 to v17 on macOS. Below is the full upgrade and restoration process for my project. Environment OS: macOS PostgreSQL: Upgraded f...
Note: The following was tested with PostgreSQL 13.1 Default setting: \x off $ psql myblog_dev myblog_dev=# SELECT "users".* FROM "users" WHERE "users"."role" = 10 LIMIT 1; The output format would be: It was difficult to read the result. Turn on th...
When we would like to sort the result-set in ascending or descending, we can use ORDER BY in SQL query. In Rails, we can use order which is derived from ActiveRecord::QueryMethods. For example, Article.all.order(published_at: :desc) Let's focus on t...
