Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group