(TIL) SQL: Cleanup Databases
drop database foo_development;
Recent Posts
(TIL) SQL: Day Of Week For A Date
Given a date in PostgreSQL
(TIL) SQL: Day Of Week By Name For A Date
By using the to_char() function with a date or timestamp, we can determine the day of the week by name (e.g. Monday). For instance, to determine what day tod...
(TIL) SQL: Count Records By Type
If you have a table with some sort of type column on it, you can come up with a count of the records in that table by type. You just need to take advantage o...
(TIL) PSQL: Checking The Type Of A Value
The pg_typeof() function allows you to determine the data type of anything in Postgres.