public List <ValuePair> getTables() { DBInterface db; db = new PostgreSQLDBInterface(new Settings().warehousedb); var pairs = db.getValuePair("id", "value", " select table_name as ID, table_name as Value FROM INFORMATION_SCHEMA.TABLES where table_type = 'BASE TABLE' and table_schema = 'public'"); var pairs2 = db.getValuePair("viewname", "viewname", "SELECT oid::regclass::text as viewname FROM pg_class WHERE relkind = 'm'"); pairs.AddRange(pairs2); return(pairs); }
public List <ValuePair> getViewColumns(string tablename) { DBInterface db; db = new PostgreSQLDBInterface(new Settings().warehousedb); var pairs = db.getValuePair("attname", "attname", "select a.attname,pg_catalog.format_type(a.atttypid,a.atttypmod), a.attnotnull from pg_attribute a" + " join pg_class t on a.attrelid = t.oid join pg_namespace s on t.relnamespace = s.oid" + " where a.attnum > 0 and not a.attisdropped" + " and t.relname = '" + tablename + "' and s.nspname = 'public'" + " order by a.attnum; "); return(pairs); }