Re: Is it possible (postgresql/mysql)

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(at)linuxlouis(dot)net
> <mailto:gonzales(at)linuxlouis(dot)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(dot)gonzales(at)linuxlouis(dot)net
> <mailto:louis(dot)gonzales(at)linuxlouis(dot)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(dot)gonzales(at)linuxlouis(dot)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