Database encoding in pg_dump - Mailing list pgsql-general

From Nikola Milutinovic
Subject Database encoding in pg_dump
Date
Msg-id 000b01c19f44$bea23ae0$0a3ea8c0@ev.co.yu
Whole thread Raw
List pgsql-general
Hi all.

Looking through the result of "pg_dump  -c -C -d www" I can see:

Create Database "www";

This doesn't set the encoding of the database. Since I'm using several different encodings for my databases, this is
unsettling.Furthermore, "createdb" uses an undocumented options for that command, in the form: 

CREATE DATABASE "www" ENCODING = $MB LOCATION = $dbpath

That is odd, to say the least, shouldn't those $MB and $dbpath be expanded?

Anyway, how should I go about my backups?

www=> select version();
                          version
------------------------------------------------------------
PostgreSQL 7.1.3 on alpha-dec-osf4.0f, compiled by cc -std

Nix.

pgsql-general by date:

Previous
From: Fritz Lehmann-Grube
Date:
Subject: How to model an AND/OR logic by relations ?
Next
From: "Steve Boyle \(Roselink\)"
Date:
Subject: Re: How to model an AND/OR logic by relations ?