From: | Daniel Henrique Alves Lima <email_daniel_h(at)yahoo(dot)com(dot)br> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | About pg_dump |
Date: | 2004-03-10 23:00:14 |
Message-ID: | 404F9DFE.7000306@yahoo.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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've 2 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 the dumped
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 !!!!
From | Date | Subject | |
---|---|---|---|
Next Message | Enver ALTIN | 2004-03-10 23:15:22 | Re: randomized order in select? |
Previous Message | Richard Grosse | 2004-03-10 22:51:03 | Re: Converting query to view - duplicate fields - solved |