Technology Insights

PostgreSQL: Run A SELECT Statement From A Linux Shell Using PSQL

Earlier today I was troubleshooting some resource issues on a PostgreSQL server and needed to test some various SELECT statements to see if any of them were causing problems. I also wanted to verify the amount of resources a SELECT statement made using PGAdmin versus the amount of resources the same SELECT statement used running it directly on the Postgres server itself. Below is information on how to run a SELECT statement from a Linux shell. In this example the server is running CentOS Linux and PostgreSQL 8.4.4.

Technology Insights

How To Insert An Accented E or é In An Email Message Composed With Outlook

Recently I have been sending a lot of emails to a colleague in Portugal whose name ends é. While I was told it is not so rude to simply not include the accent above the E I actually prefer to include the accent to display respect since he actually includes the accent over the E in his signature. Since I am using Outlook 2007 the below Outlook keyboard shortcut will provide the easiest method for you to insert an E with an accent over the top in emails that you compose. After information related specifically to the accent over the E I also discuss inserting other non English symbols into email messages composed with Outlook.