-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > In postgresql all databases are stored in /data/base directory in > numbers form and all the related tables with that database are stored in > that directory again in numbers form. > so there is any command or query to see the original table names. > just like:- select * from pg_stat_database; for databases. You can find the mapping between the "numbers" on disk and the tables by looking at the "relfilenode", "relname" and "relkind" columns of the pg_class table. However, it is best to not mess with those files at all. What are you trying to do? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200312070810 -----BEGIN PGP SIGNATURE----- iD8DBQE/0yb5vJuQZxSWSsgRAoOMAJ9FZsojXzvCVgrM6Tv0B3f+eI0k8QCg6X8C fqQi82DmYdZduq4lwADIou0= =92w+ -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
