Re: how to search for relation by name? - Mailing list pgsql-general

From Tom Lane
Subject Re: how to search for relation by name?
Date
Msg-id 528.1240508046@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to search for relation by name?  (zach cruise <zachc1980@gmail.com>)
List pgsql-general
zach cruise <zachc1980@gmail.com> writes:
> Thanks! I just created new database using old database as template,
> and everything got copied over without errors. is that recommended
> over pg_dump though when just recreating database for different
> encoding?

It's pretty much guaranteed not to work, since the data will just be
copied without any encoding conversion.  You could possibly get away
with it if the database is empty of data.

            regards, tom lane

pgsql-general by date:

Previous
From: zach cruise
Date:
Subject: utf8 encoding for template0 and template1?
Next
From: Merlin Moncure
Date:
Subject: Re: Dynamic SQL in Function