Friday, 9 September 2022

Postgresql List Index

 SELECT TABLENAME,INDEXNAME,INDEXDEF FROM PG_INDEXES 

WHERE SCHEMANAME = 'mydatabase' ORDER BY TABLENAME,INDEXNAME;

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Kiro - Core Features

What is Kiro Kiro is an innovative AI-powered IDE that revolutionizes software development through intelligent assistance and structured wor...

  • CACHING in Snowflake
    Result Cache Stores the results of a query (Cloud Services) Same queries can use that cache in the future Table data has not changed Micro-p...
  • List
    #Sample   thislist = [ "apple" , "banana" , "cherry" ] print ( "MyList : " , thislist ) ​ thislist...
  • Create Index
     CREATE INDEX sync_idx_abc ON schemaname.tablename(columnname);