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

frederic.germaneau@bull.net writes:[color=blue]
> 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.[/color]
[color=blue]
> I don't know how to do that.
> \d <tableName>, \d+ <tableName>, \db+ don't show this information[/color]

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