"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 Wong||Date: 2008-08-14 01:29:44|
|Subject: Supported by latest Debian version?|
|Previous:||From: Tom Lane||Date: 2008-08-14 00:49:35|
|Subject: Re: Contrib/uuid Missing |