Postgres Pro
Downloads
Home   >   mailing lists

Thread: Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

From
sunpeng
Date:
Hi,Frirends,
  Are there any commands in pgsql/bin/ corresponding "create tablespace"?
  I know:
  createuser <==> create role
  createdb <==>create database
  Thanks!
peng

Re: Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

From
Magnus Hagander
Date:
On Mon, Aug 6, 2012 at 11:22 AM, sunpeng <bluevaley@gmail.com> wrote:
> Hi,Frirends,
>   Are there any commands in pgsql/bin/ corresponding "create tablespace"?
>   I know:
>   createuser <==> create role
>   createdb <==>create database

Hi!

No, but you can always use:
psql -c "create tablespace foo..."


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

Re: Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

From
David Salisbury
Date:

On 8/6/12 3:31 AM, Magnus Hagander wrote:
> On Mon, Aug 6, 2012 at 11:22 AM, sunpeng<bluevaley@gmail.com>  wrote:
>> Hi,Frirends,
>>    Are there any commands in pgsql/bin/ corresponding "create tablespace"?
>>    I know:
>>    createuser<==>  create role
>>    createdb<==>create database
>
> Hi!
>
> No, but you can always use:
> psql -c "create tablespace foo..."
>
>

Wouldn't a tablespace in Pg simply be a directory..  ?