Re: COPYING A DATABASE TO ANOTHER TABLESPACE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "JORGE MALDONADO" <jorgemal1960(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: COPYING A DATABASE TO ANOTHER TABLESPACE
Date: 2008-08-14 00:53:52
Message-ID: 18573.1218675232@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"JORGE MALDONADO" <jorgemal1960(at)gmail(dot)com> writes:
> I created a database in the default tablespace and added the required
> objects like tables and indexes. Now, I noticed that I need it in a
> different tablespace. I know that one way to solve this issue is to create
> the database again and add tables and indexes.
> Is it possible to get a copy of my complete database from the default
> tablespace to another?

Try CREATE DATABASE with the original DB as template.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Candace Wong 2008-08-14 01:29:44 Supported by latest Debian version?
Previous Message Tom Lane 2008-08-14 00:49:35 Re: Contrib/uuid Missing