Sweet (regarding the single interface)! Jon, I was under the impression that varchar() was still a valid datatype in Postgre, and would not require changing to 'character varying'.
http://www.postgresql.org/docs/8.2/static/datatype-character.html Am I mis-reading that? Dave, Thanks for the tips! Thanks, Matt On 1/10/07, Jon Clausen <[EMAIL PROTECTED]> wrote: Some common datatype conversions for your adventure: :-) > MSSQL | Postgres > ---------------------------------------------------- > IDENTITY(1,1) = serial > varchar = character varying > datetime = timestamp without time zone > int = integer > text = text > > If you migrate the data using DTS and then change the column types to > serial later, you may need to run the following script on each table > to establish the next sequence value for auto-incrementing (With your > variables inserted for the table variables of course): > > SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('#table#', > '#table_id#'), (SELECT max(#table_id#) FROM #table#), true); > > Good luck! > > Jon > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4