Run SQL Files in psql Shell

When using PostgreSQL DBMS, you may need to run some SQL commands to populate a database or run some specific commands. You may also want to run these commands as a specific user. If that user doesn't use peer authentication, you'll have to run the S...