Monday, 31 October 2022

Postgresql - To get the list of tables from a schema

 SELECT 

    table_name 

FROM 

    information_schema.tables 

WHERE 

    table_schema = 'abc'

AND 

    table_type = 'BASE TABLE'

No comments:

Data Sharing

  1. Create Share CREATE SHARE my_share; 2. Grant privileges to share GRANT USAGE ON DATABASE my_db TO SHARE my_share; GRANT USAGE ...