About pg_dump - Mailing list pgsql-sql

From Daniel Henrique Alves Lima
Subject About pg_dump
Date
Msg-id 404F9DFE.7000306@yahoo.com.br
Whole thread Raw
List pgsql-sql
Hi, everybody !
   I don't know if this is the best list to ask this question but if it 
doesn't, please forgive me (should i try pgsl-general, maybe ?)...   We have a postgresql database in production and
i've2 questions 
 
about pg_dumpall boring me. We "dump" both ddl and data as SQL commands, 
so :
   1. Does the created sql script respect the database encoding (will 
chars be writen as utf-8 chars or iso-8859-1 char or ...) ?   2. We've a bytea in one table. What exactly happens with
thedumped 
 
data ? Is there any trouble with it ?
   I believe that we must to worry now (earlier). I don't want to 
expect until we must to restore database backup to descover that dumping 
data is corrupted :-)

                Thanks in advance !!!!



pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: Inserting data in a table using sub-selects]
Next
From: Richard Grosse
Date:
Subject: Re: Converting query to view - duplicate fields - solved