I have created Library object in my Redshift database using below code. Now I want to see in the system tables where all my library properties are saved\stored.

CREATE LIBRARY F_URLPARSE
LANGUAGE PLPYTHONU
FROM 'xxxxx'
CREDENTIALS 'xxxxx'
REGION AS 'xxx';

PS:Just assume xxx are my properties, here I am not mentioned due to privacy issue.

So when I am using PG_LIBRARY system view, I can only get the name of my object but no properties.

select * from pg_library;

name       | language_oid | file_store_id | owner
f_urlparse |       108254 |          2000 |   100

Finally, I need to get my library properties that I have given in script

FROM 'xxxxx'
CREDENTIALS 'xxxxx'
REGION AS 'xxx'

Please any one can help me to look at my library properties in database?

0

There are 0 best solutions below