Re: moving from MySQL to pgsql

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Sim Zacks <sim(at)compulab(dot)co(dot)il>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: moving from MySQL to pgsql
Date: 2012-10-11 03:17:07
Message-ID: 50763A33.3060100@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 10/10/2012 02:18 AM, Sim Zacks wrote:

>> 2) I run MySQL from a USB stick.
>> There is no installation required (on WinXP.). (not tried on Ubuntu)
>> Is it the same for pgsql?
> To use postgres on a USB stick, see
> http://www.postgresonline.com/journal/archives/172-Starting-PostgreSQL-in-windows-without-install.html
>
>> 3) Can I simulate MySQL's TINYINT data-type (using maybe the custom
>> data type or something else)
> You can either use bool or smallint with a constraint.

Or he could create a custom type easily enough.

JD

>
> Sim

--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2012-10-11 03:42:18 Re: Planner chooses multi-column index in 9.2 when maybe it should not
Previous Message Sean Chittenden 2012-10-11 03:03:26 Re: 'full_page_writes=off' , VACUUM and crashing streaming slaves...