I have inherited maintaining and extending SQL Power Architect projects in source control which are used to generate the DDL for project DB schemas. We are currently using PostgreSQL 9.5 and SQL Power Architect 1.0.8. (We are using SQL Power Architect to attempt to keep the schema DB-agnostic, in the event the project will eventually migrate to a different type of DB.)

If it is possible to specify UUID columns (aka GUIDs) in Power Architect for table schemas we generate, can anyone tell me which Type needs to specified for the column property of those provided in the Power Architect UI's type list? (ARRAY, DISTINCT, LONGNVARCHAR/LONGVARCHAR, VARCHAR/NVARCHAR, OTHER, UNKNOWN, etc.) Do any of these equate to/generate a UUID column?

  • 2
    Here's a really old post off the Power Architect forums that recommends making a custom type for UUID: sqlpower.ca/forum/posts/list/2706.page This is untested, YMMV, etc. Hope it helps though. – Jacob H Jun 15 '17 at 20:34
  • @JacobH thanks for letting me know about that thread! I just tracked down this video on creating custom data types in SQL Power Architect: link and that appears to be a feature of "Enterprise Edition", which is pretty sad... and not really worth $50k, so I guess I'll have to settle for using BIGINTs or something equally silly. – justinb Jun 15 '17 at 21:38
  • varchar(38) I believe for guids. Good luck! – Jacob H Jun 16 '17 at 1:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.