Looking further,
it seems that the data is still all there...
when i select certain tables, their contents appear, but they are not in the \dt list. (this is using psql)
im currently trying to dump the database before i go further, but it wont let me with the error:
pg_dump: missing pg_database entry for this database
i am proceeding very carefully so any advice would be greatly appreciated.
tia, vincent