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.