Luiz K. Matsumura wrote: > By the way, > > select setting AS default_tablespace from pg_show_all_settings() x(name > text, setting text, unit text, category text, short_desc text, extra_desc > text, context text, vartype text, source text, min_val text, max_val text) > where name = 'default_tablespace' > > and > > select current_setting('default_tablespace' ) > > can be considered equivalent ? Probably. Also try select * from pg_settings; -- Alvaro Herrera Developer, http://www.PostgreSQL.org/ "Industry suffers from the managerial dogma that for the sake of stability and continuity, the company should be independent of the competence of individual employees." (E. Dijkstra) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings