Re: mysql create table -> psql

expect wrote:

>On Tue, 09 Sep 2003 09:36:08 -0400
>Scott Cain <cain(at)cshl(dot)org> wrote:
>
>
>
>>You might want to take a look at a Perl module, SQL::Translator, which
>>translates schema elements (table creates, indexes, views) from one DB's
>>SQL to another. I don't know if the S::T on CPAN is up to date, so you
>>might want to try their website to get the CVS version:
>>
>>http://sqlfairy.sourceforge.net/
>>
>>
>
>Funny name, thanks. It's amazing how I didn't find this via google.com.
>Is it just me or is google less effective than it once was? Sure seems like it.
>I think they're going to have to modify their model.
>
>
>
>>Scott
>>
>>
>>On Tue, 2003-09-09 at 02:10, expect wrote:
>>
>>
>>>Hello,
>>>
>>>Trying to get this MySql create table command to work, no luck.
>>>
>>>create sequence serial;
>>>
>>>CREATE TABLE outbound (
>>>source char(100) default '',
>>>destination char(100) default '',
>>>sport int4 default 0 NOT NULL,
>>>dport int4 NOT NULL default 0,
>>>time timestamp NOT NULL default '0000-00-00 00:00:00',
>>>id int8 default nextval('serial') not null,
>>>constraint id PRIMARY (id)
>>>);
>>>
>>>
>>>I get a parse error:
>>>ERROR: parser: parse error at or near "(" at character 279
>>>
>>>
>>>---------------------------(end of broadcast)---------------------------
>>>TIP 8: explain analyze is your friend
>>>
>>>
>>--
>>------------------------------------------------------------------------
>>Scott Cain, Ph. D. cain(at)cshl(dot)org
>>GMOD Coordinator (http://www.gmod.org/) 216-392-3087
>>Cold Spring Harbor Laboratory
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 7: don't forget to increase your free space map settings
>>
>>
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
>
I think google's reach into technical sites is diminishing. We generate
SOOOOOOOOOOOO much traffic on all the open source AND closed source
discussion groups, it's staggering.

Jeesh, it would be intereseting to know how many words, characters, etc
were in each of those domains. I be the folks at marc.theaimsgroup.com
could give us an idea about thiers plus add in sourceforge, and it'd be
a major part of it. Well, then there's the stuff on usenet that's not on
listserves.