Re: Is it possible (postgresql/mysql) - Mailing list pgsql-general

Harald,
I had thought of that, but I wasn't sure if there was/is a way to create
the index's upon table creation, as it appears is possible with MySQL.

As for the replacing of varchar(xx) with a text data type, why do you
recommend this?  I want to stay as close as I can to the original
code...but if you think there is a good reason and that it won't
conflict with something else, then I'd like to know.  Granted,
varchar(xx) is nothing but a string of characters, potentially xx in
length, and a text datatype is also just a string of characters, I would
wonder if possibly there would be a string comparison that would treat
these different on the single fact of different datatype?

Thanks for your help Harald!

Harald Armin Massa wrote:

> Louis,
>
> indizes are simply created outside the create table
>
>
> CREATE INDEX someTable_Date_create
>   ON someTable
>   USING btree
>   (date_create);
>
> As you are working on transferring, maybe you like to drop those
> varchar(xx) and replace them with text. Saves a lot of hassle lateron.
>
> Harald
>
>
>
> On 8/16/06, *louis gonzales* <gonzales@linuxlouis.net
> <mailto:gonzales@linuxlouis.net>> wrote:
>
>     Hello List,
>     PostgreSQL 8.0.1 (on Solaris 9)
>     There is a PERL program that a friend purchased which is used to
>     create
>     tables on a MySQL database, and of course ;) I want to run this on a
>     PostgreSQL database server instead.  The below is the code:
>     $sth=runSQL("CREATE TABLE someTable (
>                         date_create bigint NOT NULL,
>                         date_end bigint NOT NULL,
>                         username VARCHAR(20) NOT NULL,
>                         $cat_definition
>                         id serial PRIMARY KEY,
>                         status VARCHAR(20) NOT NULL,
>                         $adfields
>                        visibility TEXT NOT NULL,
>                        priority TEXT NOT NULL,
>                        template TEXT NOT NULL,
>                        view bigint DEFAULT 0 NOT NULL,
>                        reply bigint DEFAULT 0 NOT NULL,
>                        save bigint DEFAULT 0 NOT NULL,
>                        updated bigint,
>                        photo VARCHAR(1) NOT NULL DEFAULT '0',
>                        INDEX(username),
>                        $cat_index
>                        INDEX(date_create) );");
>
>     What my question is, the "INDEX(...)" function calls, which work this
>     way on MySQL, don't work in PostgreSQL.  Does anybody know what a
>     synonymous way to modify the above code, for compatibility with
>     PostgreSQL?
>
>     FYI:    yourVariable  INT UNSIGNED AUTO_INCREMENT(MySQL)
>                 can be replaced by
>                yourVariable serial
>
>     Thanks group!
>
>     --
>     Email:    louis.gonzales@linuxlouis.net
>     <mailto:louis.gonzales@linuxlouis.net>
>     WebSite:  http://www.linuxlouis.net <http://www.linuxlouis.net>
>     "Open the pod bay doors HAL!" -2001: A Space Odyssey
>     "Good morning starshine, the Earth says hello." -Willy Wonka
>
>
>     ---------------------------(end of
>     broadcast)---------------------------
>     TIP 5: don't forget to increase your free space map settings
>
>
>
>
> --
> GHUM Harald Massa
> persuadere et programmare
> Harald Armin Massa
> Reinsburgstraße 202b
> 70197 Stuttgart
> 0173/9409607
> -
> Let's set so double the killer delete select all.



--
Email:    louis.gonzales@linuxlouis.net
WebSite:  http://www.linuxlouis.net
"Open the pod bay doors HAL!" -2001: A Space Odyssey
"Good morning starshine, the Earth says hello." -Willy Wonka