Postgres Pro
Downloads
Home   >   mailing lists

copying a large database to change encoding - Mailing list pgsql-general

From Matthew Chambers
Subject copying a large database to change encoding
Date
Msg-id 543D5DD4.3020906@wetafx.co.nz
Whole thread Raw
Responses Re: copying a large database to change encoding  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: copying a large database to change encoding  (Albe Laurenz <laurenz.albe@wien.gv.at>)
List pgsql-general
Tree view

Would something like this work best, or is it better to use pgdump?

CREATE DATABASE newDatabase TEMPLATE oldDatabase ENCODING 'UTF8'

Does using a template  do a file system copy or just SQL copy everything over?

-Matt

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Where should I post 3rd party product announcements?
Next
From: Adrian Klaver
Date:
Subject: Re: copying a large database to change encoding