Re: pg_dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Wasim Devale <wasimd60@xxxxxxxxx>
Subject: Re: pg_dump
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Tue, 13 Aug 2024 05:35:02 -0700
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, Holger Jakobs <holger@xxxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAB5fag71Y5bUiO1X+FGUH6o23Qa0PZOQBLVQW3g3bUvPtxkO4Q@mail.gmail.com>
References: <CAB5fag579JWutV2KyDcKVPpiba=H55k1vx8sxc8RPKyp8ssgEQ@mail.gmail.com> <7b149653-4992-9285-d9af-53929497f4e8@jakobs.com> <CAB5fag6zyWM8BwXDskOCu5OOruxaV9wUjEp-tpTO63EjGXRivQ@mail.gmail.com> <1170092.1723530800@sss.pgh.pa.us> <CAB5fag71Y5bUiO1X+FGUH6o23Qa0PZOQBLVQW3g3bUvPtxkO4Q@mail.gmail.com>

On Monday, August 12, 2024, Wasim Devale <wasimd60@xxxxxxxxx> wrote:

Then what might be the solution for it if I am only concerned about using pg_dump

Create a new table to house the bytea data, copy the bytea data to it, drop the bytea column from the existing table.

David J.

References:
- pg_dump
  - From: Wasim Devale
- Re: pg_dump
  - From: Holger Jakobs
- Re: pg_dump
  - From: Wasim Devale
- Re: pg_dump
  - From: Tom Lane
- Re: pg_dump
  - From: Wasim Devale

Prev by Date: Re: Function problem
Next by Date: AW: No Message "PostgreSQL, contrib, and documentation successfully made. Ready to install."
Previous by thread: Re: pg_dump
Next by thread: character problem
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux