Tablespace Default Behavior

From: harpagornis <shenlong(at)runbox(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Tablespace Default Behavior
Date: 2017-03-30 01:11:54
Message-ID: 1490836314764-5952910.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I am somewhat new to Postgresql. I cant seem to create a table in a
non-default tablespace. In the postgresql.conf file, I have:
default_tablespace = ''".

When I create a table, like this:

CREATE TABLE myschema.mytable (rc_id integer NOT NULL) TABLESPACE
my_space;

and then I do:

select * from pg_tables where schemaname ='myschema';

the tablespace is blank for the new table. When I look in PgAdmin, the
tablespace shows up as "pg_default." What do I need to change to create
the table in the desired tablespace? Thank you.

--
View this message in context: http://www.postgresql-archive.org/Tablespace-Default-Behavior-tp5952910.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shaun Cutts 2017-03-30 01:19:56 inevitability of to_date() when converting representations which don't represent whole timestamps
Previous Message Cherio 2017-03-29 21:25:02 Re: Vacuuming tables with BRIN index and CLUSTER ON index