dealing with disappearing position: 'fixed' on overflow?

2019-08-21

 | 

~3 min read

 | 

511 words

Have you ever tried to have an element overflow when one of its children is in a fixed positioned relative to it? Fun fact: It doesn’t work…

postgres: getting the owner of tables

2019-08-20

 | 

~2 min read

 | 

264 words

I was trying to modify a table today when I hit an error: . To figure out who the owner was so that I could ask them to modify the table on…

reminder: logging into postgres with shell commands

2019-08-19

 | 

~3 min read

 | 

595 words

PGAdmin, Dbeaver, etc. are useful GUIs for managing and reviewing Postgres databases. Sometimes, however, there’s a desire to login via the…

adding columns to postgres tables after creation

2019-08-18

 | 

~3 min read

 | 

543 words

If you already have a table created in Postgres, how can you modify it to add a new column? Similar to adding constraints after a table has…

adding a unique constraint to postgres tables after creation

2019-08-17

 | 

~3 min read

 | 

409 words

How do you add a unique constraint to a table in Postgres if it’s already been created? Most of the time, we add unique constraints to a…

Hi there and thanks for reading! My name's Stephen. I live in Chicago with my wife, Kate, and dog, Finn. Want more? See about and get in touch!