[CPS-users] Re: CPS SQL Directory Creation

[Olivier Grisel]

Joshua Kramer a écrit :
> Greetings,
> 
> I have a new CPS SQLDirectory object created and connected to my 
> Postgres database.  I have specified the schemas to use for this 
> SQLDirectory.
> 
> Now, how do I export the schemas to actually create a table in the 
> database?  By browsing to the schemas in ZMI, I can see what field types 
> they are, but not how long they are (so I can't create a table manually...)

AFAIK there is no such tool to convert a CPS Schema into its SQL counterpart.

AFAIK #2 postgres can use VARCHAR() fields so that you need not specify the size 
of the field (but I'm not an SQL guru).

-- 
Olivier