Search Postgresql Archives

Re: best way to reference tables

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

 



"TJ O'Donnell" <tjo@xxxxxxx> writes:
> I guess what I'm asking is: Is there a better way to keep track of a
> table once it's registered in my master table than just to put its
> name in my master table?  Some system oid type thing that stays fixed
> in spite of renames or other tables mods?

Yeah, you can store the pg_class OID of the table, instead of (or in
addition to) its name.  This is exactly what the system itself considers
to be the "identity" of the table.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[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 Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux