tablespaces not working

Hi,

I log into my database, then i do the following select statement, SELECT *
FROM pg_tables; this lists the
following:

schemaname tablename tableowner tablespace.

pg_catalog | pg_authid | postgres | pg_global
pg_catalog | pg_database | postgres | pg_global
public | jbm_tx | jbossesb |
public | jbm_role | jbossesb |

where the the tables i created are the ones with jbm in it. My question is
i created a tablespace and it looks like it is not being added to the table.
I do not insert my tables directly and wanted to know if there's a way to
automatically associate any table created within the database with a certain
tablespace.

i looked online and found the following command, but it still doesnt work.

SET default_tablespace = jbossuddidata;

i set this when i was creating my database.

echo create user jbossuddi with encrypted password "'"$1"';"
echo create database jbossuddi with owner postgres';'
echo create tablespace jbossuddidata owner jbossuddi location
"'/h/COTS/PostGreSQL/tablespaces/jbossuddi';"

SET default_tablespace = jbossuddidata;

--
View this message in context: http://www.nabble.com/tablespaces-not-working-tp17652605p17652605.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.