| From: | Michael Shapiro <mshapiro51(at)gmail(dot)com> |
|---|---|
| To: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | SQL for views |
| Date: | 2019-10-17 17:44:44 |
| Message-ID: | CAGCvxeYqRdnb9bHkHYqESYyj9ub23DcKx93nzNwPSTPhVUJ0PQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
How does PgAdmin extract the sql for a view?
If I run
select definition from pg_catalog.pg_views where viewname = 'xxx' and
schemaname='yyy'
the tables in the FROM clauses may or may not be fully qualified, depending
on the current search_path. If the search_path includes the schema for a
table, that table will not be fully qualified
PgAdmin seems to be able to always make sure that the tables are fully
qualified. How does it do that?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alex Williams | 2019-10-17 20:09:05 | Re: Is pgadmin4 being developed at Microsoft? |
| Previous Message | Aditya Toshniwal | 2019-10-17 17:10:22 | Re: Seriously? MASTER PASSWORD REQUIRED Again?!#$@! |