losing schema name in pg_dump

From: c k <shreeseva(dot)learning(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: losing schema name in pg_dump
Date: 2012-05-20 18:00:54
Message-ID: CAN2Y=uOekJyn8i4rONN0SOCTZhFFJ0i+VLkkNFyEKGQYVKZEsA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Many times I have to dump all objects from a schema (single schema holding
only functions and views) in plain text format. It is found that pg_dump
includes a set search_path statement at the beginning and drops all
occurrences of the schema name (to which dumped object belongs) from
function/view bodies even if they are explicitly defined while creating
functions/views.

Functions or view definition from information_schema tables shows the
explicitly defined schema names but pg_dump does not shows them. Is there
any switch to change this behaviour? Or pg_dump has this by default and we
can not change this?
This makes it problematic to maintain the software available for another
RDBMS as for most other RDBMS we have to explicitly define schema names
always.

Thanks,

C P Kulkarni

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Townsend 2012-05-20 19:52:38 Re: Libpq question
Previous Message c k 2012-05-20 17:48:14 Re: suggestion for backup (pg_dump)