| 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: | Whole Thread | Raw Message | 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 |