On 24/05/11 18:58, Jasmin Dizdarevic wrote:
> Alright, I've misunderstood this issue. Do you have to escape bytea
> columns during export or import? And how you would do this?
Some database drivers and some apps don't understand the new hex output
format for bytea columns.
IIRC, the format change
Alright, I've misunderstood this issue. Do you have to escape bytea columns
during export or import? And how you would do this?
Ty
2011/5/24 Craig Ringer
> On 24/05/11 14:30, [email protected] wrote:
> > We had trbls with our drupal site, because some settings are stored in
> bytea c
On 24/05/11 14:30, [email protected] wrote:
> We had trbls with our drupal site, because some settings are stored in bytea
> columns. I think lobs are a problem too, but pls see the pg_dump docs for
> details.
Is it possible that you are referring to the `bytea_output' setting in
Postg
On 23/05/2011 11:19 PM, [email protected] wrote:
Just be careful with pg_dump, if you have binary data stored in your 8.4 db. In
default mode it just export text.
Er ... what?
Can you elaborate on that?
Do you mean large objects? bytea fields? Something else?
--
Craig Ringer
Tech
Baumanis
Cc:
Subject: Re: [SQL] Which version of PostgreSQL should I use.
Just thought I would update this myself.
Last night I managed to have a chat with some people about this on IRC.
Turns out we're in pretty good shape.
We already know about the changes to implicit casting and we have a
Just thought I would update this myself.
Last night I managed to have a chat with some people about this on IRC.
Turns out we're in pretty good shape.
We already know about the changes to implicit casting and we have always used
UTF-8 for encoding, too.
So the changes from 8.4 don't seem to be o
> We're currently using psql 8.1 and are on the way to upgrading to 8.4.
The tools "pg_dump" & "pg_restore" are used to extract and re-create databases.
Can be used for chores such as deploying from development to production,
backing up, and upgrading.
http://www.postgresql.org/docs/current/stat
Hi there,
Let me first preface this with, I am not a PostgreSQL admin.
I am a web developer who happens to use PSQL as the back-end for my company's
app.
We did have a dedicated DBA / system admin - but he has recently resigned.
I know enough about psql - to be able to create / drop databases...
