> 2. We're using pg-admin to work with postgres. It doesn't seem possible to
> modify tables in pg-admin once you've created them, you have to delete and
> add. Is there another pg client that supports modifying tables ?
Depends on what you want to change:
Drop a column -
Sorry - Drop table and recreate.
Add Column -
ALTER TABLE mytable ADD COLUMN mycolumn int4;
Change Column Name -
ALTER TABLE mytable RENAME COLUMN mycolumn TO newcolumn;
http://www.pgexplorer.com
GUI Postgres TOOL