From: | Együd Csaba <csegyud(at)vnet(dot)hu> |
---|---|
To: | "Pgsql-General(at)Postgresql(dot)Org (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_dump, bytea, dump order questions |
Date: | 2004-06-07 08:38:27 |
Message-ID: | 001601c44c6a$ce40e3e0$230a0a0a@compaq |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi All,
I'd like to dump out my database using plain text format. Everything is ok,
but the bytea filds.
Restoring the dump file (using <<psql -f LO_TRY_INSERT_BYTEA.sql tmp7>>) it
sends an error message like
psql:LO_TRY_INSERT_BYTEA.sql:14: ERROR: Bad input string for type bytea
Trying dumping with copy commands it sends this error:
psql:LO_TRY_COPY_BYTEA.sql:13: lost synchronization with server, resetting
connection
I used <<pg_dump -d ...>> and <<pg_dump ...>> formats for creating dump
files.
How should I use pg_dump to make it able to back my binary data correctly?
An other question. How can I make psql to change the dupm order of db
objects? My problem is, that one of my table fields has a default clasuse
using a plpgsql function. As being functions dumped after table definitions
creating these tables fail. What can I do in order to avoid these problems -
without modifying every dump file by hand?
Any help is appreciated.
Thank you,
-- Együd Csaba
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com)
Version: 6.0.699 / Virus Database: 456 - Release Date: 2004. 06. 04.
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-06-07 09:09:09 | Re: [HACKERS] CREATE DATABASE on the heap with PostgreSQL? |
Previous Message | Rajesh Kumar Mallah | 2004-06-07 07:58:22 | Tsearch case sensitive with dotted search terms. |