How to generate SERIAL type in postgres mode

2007-10-29
2013-03-06
  • felixcoutinho

    felixcoutinho - 2007-10-29

    Hello men!
    I can't generate sql script contains autoincrement field, SERIAL type in postgres sql.
    Have a table contains 2 fields, the primary key with autoincrement flag e other field with varchar type, is only functional test.
    But i generate sql script a get this:

    CREATE TABLE Table_01 (
      id INTEGER   NOT NULL ,
      nkn VARCHAR(20)      ,
    PRIMARY KEY(id));

    Without autoincrement, SERIAL type.
    What a procede? How to make this?

    My source file is follow XML:

    -------------------------------------------------------------------------
    <?xml version="1.0" standalone="yes" ?>
    <DBMODEL Version="4.0">
    <SETTINGS>
    <GLOBALSETTINGS ModelName="teste" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="0" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="" HPageCount="4.0" PageAspectRatio="1.440892512336408" PageOrientation="1" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="1" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="1" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Tahoma" CanvasWidth="4096" CanvasHeight="2842" />
    <DATATYPEGROUPS>
    <DATATYPEGROUP Name="Numeric Types" Icon="1" />
    <DATATYPEGROUP Name="Date and Time Types" Icon="2" />
    <DATATYPEGROUP Name="String Types" Icon="3" />
    <DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
    <DATATYPEGROUP Name="User defined Types" Icon="5" />
    <DATATYPEGROUP Name="Geographic Types" Icon="6" />
    <DATATYPEGROUP Name="Common data types" Icon="3" />
    </DATATYPEGROUPS>
    <DATATYPES>
    <DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="UNSIGNED" Default="1" />
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="UNSIGNED" Default="1" />
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="UNSIGNED" Default="1" />
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="UNSIGNED" Default="0" />
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="UNSIGNED" Default="1" />
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="UNSIGNED" Default="0" />
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="precision" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    <PARAM Name="decimals" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    <PARAM Name="decimals" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    <PARAM Name="decimals" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    <PARAM Name="decimals" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    <PARAM Name="decimals" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    <PARAM Name="decimals" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="ZEROFILL" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    </DATATYPE>
    <DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    </DATATYPE>
    <DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="BINARY" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    <OPTIONS>
    <OPTION Name="BINARY" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="values" />
    </PARAMS>
    </DATATYPE>
    <DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="values" />
    </PARAMS>
    </DATATYPE>
    <DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <OPTIONS>
    <OPTION Name="BINARY" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <OPTIONS>
    <OPTION Name="BINARY" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <OPTIONS>
    <OPTION Name="BINARY" Default="0" />
    </OPTIONS>
    </DATATYPE>
    <DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="44" IDGroup="6" TypeName="CHAR(1)" Description="Common Boolean Format" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="45" IDGroup="6" TypeName="CHAR(15)" Description="Common DATE/TIME format (YYYYMMDDHHMMSSSSS)" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="47" IDGroup="6" TypeName="CHAR" Description="A common fixed-length string." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    </DATATYPE>
    <DATATYPE ID="48" IDGroup="6" TypeName="VARCHAR" Description="A common variable-length string." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    <PARAMS>
    <PARAM Name="length" />
    </PARAMS>
    </DATATYPE>
    <DATATYPE ID="49" IDGroup="6" TypeName="INTEGER" Description="Common integer data type" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="50" IDGroup="6" TypeName="FLOAT" Description="Common float data type." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    <DATATYPE ID="51" IDGroup="6" TypeName="DOUBLE" Description="Common double data type." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
    </DATATYPE>
    </DATATYPES>
    <COMMON_DATATYPES>
    <COMMON_DATATYPE ID="47" />
    <COMMON_DATATYPE ID="48" />
    <COMMON_DATATYPE ID="49" />
    <COMMON_DATATYPE ID="50" />
    <COMMON_DATATYPE ID="51" />
    <COMMON_DATATYPE ID="44" />
    <COMMON_DATATYPE ID="45" />
    </COMMON_DATATYPES>
    <TABLEPREFIXES>
    <TABLEPREFIX Name="Default (no prefix)" />
    </TABLEPREFIXES>
    <REGIONCOLORS>
    <REGIONCOLOR Color="Red=#FFEEEC" />
    <REGIONCOLOR Color="Yellow=#FEFDED" />
    <REGIONCOLOR Color="Green=#EAFFE5" />
    <REGIONCOLOR Color="Cyan=#ECFDFF" />
    <REGIONCOLOR Color="Blue=#F0F1FE" />
    <REGIONCOLOR Color="Magenta=#FFEBFA" />
    </REGIONCOLORS>
    <POSITIONMARKERS>
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
    </POSITIONMARKERS>
    </SETTINGS>
    <METADATA>
    <REGIONS>
    </REGIONS>
    <TABLES>
    <TABLE ID="1000" Tablename="Table_01" PrevTableName="" XPos="135" YPos="166" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
    <COLUMNS>
    <COLUMN ID="1002" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
    <OPTIONSELECTED>
    <OPTIONSELECT Value="1" />
    <OPTIONSELECT Value="0" />
    </OPTIONSELECTED>
    </COLUMN>
    <COLUMN ID="1006" ColName="nkn" PrevColName="" Pos="1" idDatatype="20" DatatypeParams="(20)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
    <OPTIONSELECTED>
    <OPTIONSELECT Value="0" />
    </OPTIONSELECTED>
    </COLUMN>
    </COLUMNS>
    <INDICES>
    <INDEX ID="1003" IndexName="PRIMARY" IndexKind="0" FKRefDef_Obj_id="-1">
    <INDEXCOLUMNS>
    <INDEXCOLUMN idColumn="1002" LengthParam="0" />
    </INDEXCOLUMNS>
    </INDEX>
    </INDICES>
    </TABLE>
    </TABLES>
    <RELATIONS>
    </RELATIONS>
    <NOTES>
    </NOTES>
    <IMAGES>
    </IMAGES>
    </METADATA>
    <PLUGINDATA>
    <PLUGINDATARECORDS>
    </PLUGINDATARECORDS>
    </PLUGINDATA>
    <QUERYDATA>
    <QUERYRECORDS>
    </QUERYRECORDS>
    </QUERYDATA>
    <LINKEDMODELS>
    </LINKEDMODELS>
    </DBMODEL>
    --------------------------------------------------------------------------------

     
    • Philippe Lotton

      Philippe Lotton - 2007-10-31

      Hi Felix,

      I'm sory to haven't your response, but may be you have a response for me :).
      I try to install the Windows version of DB Designer for postgres, but I have a problem with the odbc driver.
      It can't connect the base ans return an error.
      Do this configuration works fine with you, except your serial type of course ?

      Thanks for reply

      Philippe

       
  • Andres Ramirez Ramos

    Hi Felix.

    Just create a new datatype

    <DATATYPE ID="45" IDGroup="5" TypeName="SERIAL" Description="autoincrementing four-byte integer, 1 to 2147483647, not true type, but merely a notational convenience for setting up unique identifier columns (similar to the AUTO_INCREMENT property supported by some other databases)" ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >

     
  • Joao Paulo Schwarz Schuler

    Dear Felix,
    I'll code that when exporting to postgres, SERIAL will be generated instead of "integer autoincrement".

    JP.

     
  • Veronica Clavijo

    sunshavi where do you create a new datatype, I need to define oracle datatypes like NUMBER, VARCHAR2 and BLOB

     
  • Andres Ramirez Ramos

    Hi verobogeyblues.

    Perhaps too late. a new data type should be created within de xml project file.

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks