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
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) |