Skip to content

Instantly share code, notes, and snippets.

@smerchek
smerchek / abbreviations.md
Created August 7, 2015 19:45
Pharmacy Abbreviations
Abbrev Direction
q EVERY
qH EVERY HOUR
qAM EVERY MORNING
qPM EVERY EVENING
qHS EVERY BEDTIME
qD EVERY DAY
qOD EVERY OTHER DAY
qWK EVERY WEEK

Keybase proof

I hereby claim:

  • I am smerchek on github.
  • I am smerchek (https://keybase.io/smerchek) on keybase.
  • I have a public key ASCbCRQMa6fnJ3sJ14paAMNA63zd95yVF6OBZkXGuQl7Ugo

To claim this, I am signing this object:

@smerchek
smerchek / find_tables_with_is_removed.sql
Last active July 9, 2019 16:13
Find all tables with a given column name (e.g. `is_removed`)
select t.table_schema,
t.table_name,
CASE WHEN EXISTS(SELECT *
FROM information_schema.columns c
WHERE c.table_name = t.table_name
and c.table_schema = t.table_schema
and c.column_name = t.table_name || '_id'
) THEN '✅' ELSE '❌' END
AS has_matching_id_column,
(SELECT c.column_name