[GENERAL] how can I find out the numeric directory name of each database in PostgreSQL 8.3

Hi, In PostgreSQL 7.x, I can use SQL: select datname, oid from pg_database to find out the numeric directory name under $PGDATA/base for each database. But it doesn't work for PostgreSQL 8.3. Is there any way I can do it for 8.3? Thanks, -- Justin Yao -- Sent via pgsql-general mailing list

Re: [GENERAL] how can I find out the numeric directory name of each database in PostgreSQL 8.3

nothing special, just curious about it. I suppose it should be able to be located by SQL. Justin Tino Wildenhain wrote: Hi, Justin Yao wrote: Hi, In PostgreSQL 7.x, I can use SQL: select datname, oid from pg_database to find out the numeric directory name under $PGDATA/base for each

Re: [GENERAL] how can I find out the numeric directory name of each database in PostgreSQL 8.3

: Justin Yao [EMAIL PROTECTED] writes: In PostgreSQL 7.x, I can use SQL: select datname, oid from pg_database to find out the numeric directory name under $PGDATA/base for each database. But it doesn't work for PostgreSQL 8.3. It works for me ... what problem are you having

Re: [GENERAL] how can I find out the numeric directory name of each database in PostgreSQL 8.3

thanks so much! Tom Lane wrote: Justin Yao [EMAIL PROTECTED] writes: But the question is, why there's no column named oid and it still works? \d doesn't show system columns. http://www.postgresql.org/docs/8.3/static/ddl-system-columns.html regards, tom lane