table localisation
Started by Nonameover 21 years ago2 messagesgeneral
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
Re: table localisation
frederic.germaneau@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