Postgres Pro
Downloads
Home   >   mailing lists

Re: COPYING A DATABASE TO ANOTHER TABLESPACE - Mailing list pgsql-novice

From Tom Lane
Subject Re: COPYING A DATABASE TO ANOTHER TABLESPACE
Date
Msg-id 18573.1218675232@sss.pgh.pa.us
Whole thread Raw
In response to COPYING A DATABASE TO ANOTHER TABLESPACE  ("JORGE MALDONADO" <jorgemal1960@gmail.com>)
List pgsql-novice
Tree view 
"JORGE MALDONADO" <jorgemal1960@gmail.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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Contrib/uuid Missing
Next
From: "Candace Wong"
Date:
Subject: Supported by latest Debian version?