Выгрузка всех таблиц из базы данных PostgreSQL в QlikView

CUSTOM CONNECT TO "Provider=QvOdbcConnectorPackage.exe;driver=postgres;host=localhost;port=4992;db=nprinting;SSLMode=prefer;UseSystemTrustStore=0;ByteaAsLongVarBinary=0;TextAsLongVarchar=0;UseUnicode=1;FetchTSWTZasTimestamp=1;MaxVarcharSize=262144;UseDeclareFetch=1;Fetch=200;EnableTableTypes=1;MoneyAsDecimal=1;QueryTimeout=30;XUserId=QQWbBLKHJOIJL498ihjioZdGC;XPassword=QQWbBLKHJOIJL498ihjioZdGCTBA;";


tables:
sql
SELECT table_name FROM information_schema.tables 
WHERE table_schema='public' and table_catalog='nprinting';

FOR i=1 to NoOfRows('tables')
 
  LET vTableName = Peek('table_name',$(i)-1,'tables');
  
 
  [$(vTableName)]:
  SQL SELECT * FROM public.$(vTableName);
  ;
  
 
  STORE [$(vTableName)] into 'C:\QVDStorage\RawData\$(vTableName).qvd' (qvd);
  
  DROP Table [$(vTableName)];
 
NEXT i
 
DROP Table tables;

CUSTOM CONNECT TO "Provider=QvOdbcConnectorPackage.exe;driver=postgres;host=localhost;port=4992;db=nprinting;SSLMode=prefer;UseSystemTrustStore=0;ByteaAsLongVarBinary=0;TextAsLongVarchar=0;UseUnicode=1;FetchTSWTZasTimestamp=1;MaxVarcharSize=262144;UseDeclareFetch=1;Fetch=200;EnableTableTypes=1;MoneyAsDecimal=1;QueryTimeout=30;XUserId=QQWbBLKHJOIJL498ihjioZdGC;XPassword=QQWbBLKHJOIJL498ihjioZdGCTBA;";

tables:

sql

SELECT table_name FROM information_schema.tables

WHERE table_schema='public' and table_catalog='nprinting';

FOR i=1 to NoOfRows('tables')

LET vTableName = Peek('table_name',$(i)-1,'tables');

[$(vTableName)]:

SQL SELECT * FROM public.$(vTableName);

;

STORE [$(vTableName)] into 'C:\QVDStorage\RawData\$(vTableName).qvd' (qvd);

DROP Table [$(vTableName)];

NEXT i

DROP Table tables;

Выгрузка всех таблиц из базы данных PostgreSQL в QlikView

0 0 голос

Рейтинг статьи

Related posts: