How do I write a script that .....

A couple of newbie questions here:

1. How do I write a script that creates a database if it doesn't exist,
but if it does, then check to see if the tables are there ?

2. How do I change databases from within psql ?

3. How do I list the tables in a database ?

Please respond directly vie email (david@cenozoa.com).

Thanks so much for any help.

David
--
____________________________
David Brusowankin
Voice: 201.287.1527
Email: david@brusowankin.net