Posts

Showing posts from March, 2021

Load JavaScript and CSS from JSON

 async function loadFile(file) { let x = await fetch(file); return await x.text(); } function loadjscssfile(fileobj){ let css = fileobj.css; let base = js.css; css.file.each(function(i){ loadjscssfile(base+'/'+i,'css'); }) let js = fileobj.js; base = js.base; js.file.each(function(i){ loadjscssfile(base+'/'+i,'js'); }) } function loadjscssfile(filename, filetype){ if (filetype=="js"){ //if filename is a external JavaScript file var fileref=document.createElement('script') fileref.setAttribute("type","text/javascript") fileref.setAttribute("src", filename) } else if (filetype=="css"){ //if filename is an external CSS file var fileref=document.createElement("link") fileref.setAttribute("rel", "stylesheet") fileref.setAttribute("type", "text/css") fileref.setAttribute("href", filename)

Get List of tables within a Postgres database

 SELECT tablename FROM pg_catalog.pg_tables WHERE schemaname != 'pg_catalog' AND schemaname != 'information_schema';