psql blah                  ; open the database named 'blah' and goto postgres command prompt
 
Welcome to psql 8.0.6, the PostgreSQL interactive terminal.
 
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit
 
paradocs=# select * from password_table where username = 'user1';

useful text email client.

Info found here: http://www.seas.upenn.edu/cets/answers/movemail.html

mutt

The above command brings you into the common mail spool, which is where all incoming mail comes to. When you quit mutt, it often asks if you want to save your read messages to /*/mbox where * is your username. This basically is moving or saving your read email to different location.

To view email saved to an alterante location:

type the letter 'c' while in mutt

This was moved to

• http://nickyeates.com/technology/unix/raid_filesystem_lvm

• Console while botting
  • CTRL+ALT+F1 to get a terminal
  • CTRL+ALT+F7 to get back to X windows
• Cant boot to OS, use LiveCD
  • LiveCD → chroot→ aptitude remove evms (example)

1. Click Applications and select Network Servers.
2. Double-click Windows Network.
3. Double-click domain ex: nickyeates.
4. Double-click computer name ex: XPWIN - click OK on the error message and click File and select Connect to Server.
5. Select Windows share for Service type.
6. Enter computer name ex: xpwin for Server.
7. Enter share name ex: linuxbkup for Folder.
8. Enter your username (username to access shared folder)
9. Enter a name for Name to use for connection
10. Click Connect
11. Enter username, password, domain, check to both checkboxes to use for duration and remember.

mount -t smbfs -o username=Administrator/nickyeates,password=**** //xpwin/linuxbkup /media/EXTERNAL

//xpwin/linuxbkup /media/EXTERNAL        smbfs   username=Administrator/nickyeates,password=**** 0 0