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
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
database. But it doesn't work for PostgreSQL 8.3.
Is there any way I can do it for 8.3?
What would you do with that name once
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
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?
forget it. I am really sorry about that.
it works for me, too.
when I did :
dbname= \d pg_database
Table pg_catalog.pg_database
Column | Type| Modifiers
---+---+---
datname | name | not null
datdba| oid | not null
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
--
Sent via pgsql-general mailing list
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
--