By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,970 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

table localisation

P: n/a
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

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.