Re: find table name

Hi the list,

I used to run oid2name to find the relation between database names and
.../data/base/<dir> but i'm interested also to identify relation between table
names, index names and files number as would try to decrease Wait I/O by
setting tables on one disk and indexes on another one.
The tables pg_class and pg_index do not give the symbolic name with the
"numbers".

Thierry Missimilly.



greg@turnstep.com wrote:

> -----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-----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org