How to export a view data from Postgresql/Phppgadmin

Question

I know how to export a table via PhpPgAdmin.

Is there a way I can export a view data out of PhpPgAdmin.

Thanks.

Answer 1

There is an option to do it through phpPGadmin as well.

1. Make the view
2. Select the view
3. underneath your columns selected for the view there is an option 'select'
4. in this select screen select the option " Select All Fields"
5. run the select
6. you get the results 30 per page
7. at the bottom of the results there is an option 'download'
8. select your kind of export you want (CSV, XHTML, ...)
9. select download

I know its a late reply but i had to search myself this one and this was the first result from google so I hope this helps other google hitters :)

Answer 2

SELECT 
    definition 
FROM 
    pg_views 
WHERE 
    schemaname = 'public' 
AND
    viewname = 'your_view';