table localisation

[frederic.germaneau]

Hi,

I'm trying to create a database with 2 tableSpaces one for data table and
one other for indexes

I have created a schema on my tablespace for datas and a table in this
schema, I would like to verify that this table is on the right tablespace.

I don't know how to do that.
\d <tableName>, \d+ <tableName>, \db+ don't show this information

Thanks

Frédéric Germaneau

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Tom Lane]

fr****************@bull.net writes:

I have created a schema on my tablespace for datas and a table in this
schema, I would like to verify that this table is on the right tablespace. I don't know how to do that.
\d <tableName>, \d+ <tableName>, \db+ don't show this information

Maybe you're using an old copy of psql? I'd expect "\d table" to show
that.

regards, tom lane

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

http://archives.postgresql.org