An interesting article today: Simple things are complicated: making a show password option. It referenced Government Design Principles: Make things open: it makes things better which I thought was an interesting and sensible government policy…
Tag Archives: show
macOS show connected servers on desktop
In Finder -> Preferences -> General there is a checkbox option to show ‘Connected servers’. Use that to show connected servers and then you can make aliases for them. I learned about this setting today over here.
Enable/Show “http://” and “https://” URL Prefix in Firefox Location Bar
Reply
Found this article which said:
Open about:config and disable browser.urlbar.trimURLs. Easy peasy!
psql show tables
I wanted to know what the analogue for MySQL ‘show tables’ was in PostgreSQL, and I found the answer, use the information_schema, here:
mysql: SHOW TABLES postgresql: \d postgresql: SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'; mysql: SHOW DATABASES postgresql: \l postgresql: SELECT datname FROM pg_database; mysql: SHOW COLUMNS postgresql: \d table postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table'; mysql: DESCRIBE TABLE postgresql: \d+ table postgresql: SELECT column_name FROM information_schema.columns WHERE table_name ='table';