Chaitany Kulkarni <shreeseva...@gmail.com> writes: > I didn't understand when user have defined schema names explicitly in > definition of the objects and most database developers insist on writing > schema names explicitly, why pg_dump is not outputting it as it is.
The short answer to that is that the internal representation of views and other objects only stores object identities, not how they were named in the input. We don't store whitespace or layout choices either, and there are various other ways that the output can vary from what you typed. So really, if you're intent on that, keeping the original source file is the way to go. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs