VegBank

A user called qa has been setup for the database and server (contact me for
password)

ssh qa@vegbank.nceas.edu

INSTRUCTIONS:

psql is the command for sql access to database.
  Please use man sql to get more information on usage. Below are some
  things to get you started.

This sql shell has tab-completion, command history and many other user
  friendly and powerfull features.

Connect to database:
$ psql [database_name]
i.e. plants_dev, plot_dev, communities_dev and framework

you should see;
 db_name=#

now you can run commands or querys.
db_name=# \d
desribes current db (i.e.) lists tables
db_name=# select * from table;
run sql commands .. note the semi-colon

db_name=# \q
   quit progam

Run a query and save output in a file:
db_name=# select plantname from plantconcept; \g outputfile
QUERY SWITCH FILENAME

Save all query results of this session to a file
 db_name=# \o filename

Original Bugzilla ID was 593