From: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com> |
---|---|
To: | Kuntal Ghosh <kuntalghosh(dot)2007(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_dump ignoring information_schema tables which used in Create Publication. |
Date: | 2017-05-22 11:52:56 |
Message-ID: | adb58840-404a-ce0c-6ea5-40ac2a2b70c9@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 05/22/2017 05:12 PM, Kuntal Ghosh wrote:
> pg_dump ignores anything created under object name "pg_*" or
> "information_schema".
In this below scenario , I am able to see - pg_dump catch the
information of table which is created under information_schema
postgres=# create database ntest;
\CREATE DATABASE
postgres=# \c ntest
You are now connected to database "ntest" as user "centos".
ntest=# create table information_schema.abc(n int);
CREATE TABLE
ntest=# create view e1 as select * from information_schema.abc;
CREATE VIEW
[centos(at)centos-cpula regress]$ pg_dump -Fp ntest > /tmp/a.a
cat /tmp/a.a
============================
SET search_path = public, pg_catalog;
--
-- Name: e1; Type: VIEW; Schema: public; Owner: centos
--
CREATE VIEW e1 AS
SELECT abc.n
FROM information_schema.abc;
============================
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Kuntal Ghosh | 2017-05-22 11:59:41 | Re: Increasing parallel workers at runtime |
Previous Message | Kuntal Ghosh | 2017-05-22 11:42:24 | Re: pg_dump ignoring information_schema tables which used in Create Publication. |