pcsoft.us.windevCopyright 2026, PC SOFT27 Jan 2018 12:19:00 Z27 Jan 2018 12:19:00 ZHello, WD 22, Postgresql I tried creating a new analysis to check the sql script generation facility. File: accountname companycode varchar(10) accountguid varchar(32) accountname varchar(60) key with duplicates companycodeaccountguid compisitekey unique When I tried to generate the sql script through Analysis - Analysis - Generation - Generate SQL scripts, I found the following things missing. 1. No way to define a primary key. 2. index is created on account name fields. 3. index is created on companycode+accountpk with NO unique key word, means duplicate values could enter. Is this the way the 'GENERATE SCRIPT' gives us the code ? I feel it's incomplete. What else is the way to maintain Analysis and its subsequent script generation in Windev ? Happiness Always BKR Sivaprakash30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64232-wd22-postgresql-analysis-and-subsequent-sql-generation/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)