Sorry for the late reply. But after comparing output results of pg_dump and
other tools in SQL format, I think it will helpful if an another switch is
provided in pg_dump to output data and definition of objects of only given
type.
e.g.
pg_dump --type views
It will export only views in given form
Chaitany Kulkarni 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 represe
Thanks for your reply.
I know that pg_dump is not intended to provide SQL script to be working in
many other DBMS. But even if I have to dump all functions/views (tables and
other objects are not changed a lot like functions/views due to changes in
business rules or behaviour) from a certain schema
shreeseva...@gmail.com writes:
> 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 dum
The following bug has been logged on the website:
Bug reference: 6660
Logged by: C P Kulkarni
Email address: shreeseva...@gmail.com
PostgreSQL version: 9.1.3
Operating system: Fedora 16
Description:
Many times I have to dump all objects from a schema (single schema ho
