Database encoding in pg_dump

From: "Nikola Milutinovic" <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu>
To: "PostgreSQL general" <pgsql-general(at)postgresql(dot)org>
Subject: Database encoding in pg_dump
Date: 2002-01-17 10:50:14
Message-ID: 000b01c19f44$bea23ae0$0a3ea8c0@ev.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Steve Boyle (Roselink) 2002-01-17 10:59:23 Re: How to model an AND/OR logic by relations ?
Previous Message Fritz Lehmann-Grube 2002-01-17 10:14:58 How to model an AND/OR logic by relations ?