Answer a question I am trying to update a bunch of columns in a DB for testing purposes of a feature. I have a table that is built with hibernate so all of the columns that are created for an embedded

Answer a question I am trying to migrate a SQLite3 database to a PostgreSQL database using the 'taps' gem ( https://github.com/ricardochimal/taps ), as described in Change from SQLite to PostgreSQL in

Answer a question I am using the following query to discover (1) the primary key columns and (2) if the columns have a default value from the information_schema in Postgresql 9.1. SELECT kcu.column_na

Answer a question Recently I needed to move objects from PostgreSQL's default schema "public" to another schema. I found this post which shows how to move tables which was great, but I also need to mo

Answer a question I want to check if a record already exist on database, but I have one json data type field and I need to compare it too. When I try check using exists? I got the following error: SEL

Answer a question I'm running node.js with an express.js server and sequelize.js. This is an API-only application, so no views written in node. I'm trying to understand how to architect associations b

Answer a question I have a problem in my request: SELECT regionn, COUNT(regionn) AS total, COUNT(last_date_o) AS ouvreurs, COUNT(last_date_o)*100/COUNT(regionn) AS ratio, COUNT(gender='mr'), COUNT(gen

Answer a question I am trying to figure out a graceful way to handle a ActiveRecord::RecordNotUnique exception globally for all my ActiveRecord code. I know about the validates_uniqueness_of validatio

Answer a question In Postgres 9.2, I have a table containing measures taken at specific points in time: CREATE TABLE measures (dt timestamptz, measure integer); INSERT INTO measures VALUES ('2015-01-1

Answer a question Table: table_name create table table_name ( given_dates timestamp, set_name varchar ); Insertion of records: insert into table_name values('2001-01-01'),('2001-01-05'),('2001-01-10')