Retrieving What variables mean when retrieving view definitions?

0 votes

1 answer

33 views

                          I'm working on a small script to transfer views over from one database to another. I can get the view definition by using select view_definition from information_schema.views where table_name = 'actor_info', however the result is  

    SELECT a.actor_id,
           a.first_name,
           a.last_name,
           group_concat(DISTINCT (((c.name)::text || ': '::text)
           || ( SELECT group_concat((f.title)::text) AS group_concat
                  FROM ((film f
                         JOIN film_category fc_1 ON ((f.film_id = fc_1.film_id)))
                        JOIN film_actor fa_1 ON ((f.film_id = fa_1.film_id)))
                 WHERE ((fc_1.category_id = c.category_id) AND (fa_1.actor_id = a.actor_id))
                 GROUP BY fa_1.actor_id))) AS film_info
      FROM (((actor a
              LEFT JOIN film_actor fa ON ((a.actor_id = fa.actor_id)))
             LEFT JOIN film_category fc ON ((fa.film_id = fc.film_id)))
            LEFT JOIN category c ON ((fc.category_id = c.category_id)))
     GROUP BY a.actor_id, a.first_name, a.last_name;

I'm looking for a way to figure which tables a and c refer to. Is there a SQL statement that can be used?

                        

Asked by daddy_raptor (1 rep)

Jan 17, 2018, 07:33 PM
Last activity: Jan 17, 2018, 08:03 PM

Retrieving What variables mean when retrieving view definitions?

Related Questions