Search Postgresql Archives

Re: a very naive question about table names in Postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






I know that on my Mac the tables are  kept in the  data directory /Users/martinmueller/Library/Application Support/Postgres/var-13.  If I go there I see that internally the tables have numbers.  Somewhere in the system there must be a table that maps the name I gave to table X  to the numerical  inside the database.


Check the pg_class table in the system catalog.  The numeric value is the OID.

https://www.postgresql.org/docs/14/catalog-pg-class.html

Craig

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux