Thanks Nathan. Actually what I needed to do is the inverse of what you've suggested (want to blank just the ec* data and keep the rest). I went ahead and did what I mentioned in my initial post (created a new database and copied the ec* files over to the current database directory) and it worked (except for wiping out my single product template which is held in one of the tables and not in static file - not to worry though - still in test mode). I still think this is not such a clean procedure. I think I need to spend more time with the Postgres docs to come up with alternatives and hopefully someone also has a better method.
