Postgres Pro
Downloads
Home   >   mailing lists

Re: Dumping views, functions, ... - Mailing list pgsql-admin

From Shoaib Mir
Subject Re: Dumping views, functions, ...
Date
Msg-id bf54be870704020745o5014082fj8417d4ca85fa1d81@mail.gmail.com
Whole thread Raw
In response to Dumping views, functions, ...  (Arnau <arnaulist@andromeiberica.com>)
List pgsql-admin
Tree view
You can use the following query to get all the views:

select 'CREATE VIEW '||viewname||' AS '||definition as viewSQL from pg_views where schemaname='<schemaname>';

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 4/2/07, Arnau <arnaulist@andromeiberica.com > wrote:
Hi all,

   Lets say that in my database I have a view named foo_view and I'd
like to dump it's definition. I'd like to do something like:

  pg_dump --view=foo_view bar_db > foo_view.log

  so I'd have in the foo_view.log file the foo_view's definition. This
same concept I'm searching to apply it to rules, functions, ...

   I have been looking into pg_dump options and I haven't found the way.
The most similar thing I have found is -t option that does what I need
but with tables. Is it possible to do this with pg_dump?

Thanks
--
Arnau

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

pgsql-admin by date:

Previous
From: Arnau
Date:
Subject: Dumping views, functions, ...
Next
From: "Sorin N. Ciolofan"
Date:
Subject: Re: Increasing the shared memory