Re: find table name

-----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 greg@turnstep.com
PGP Key: 0x14964AC8 200312070810

-----BEGIN PGP SIGNATURE-----

iD8DBQE/0yb5vJuQZxSWSsgRAoOMAJ9FZsojXzvCVgrM6Tv0B3f+eI0k8QCg6X8C
fqQi82DmYdZduq4lwADIou0=
=92w+
-----END PGP SIGNATURE-----