Re: moving from MySQL to pgsql - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: moving from MySQL to pgsql
Date
Msg-id 50763A33.3060100@commandprompt.com
Whole thread Raw
In response to Re: moving from MySQL to pgsql  (Sim Zacks <sim@compulab.co.il>)
List 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


pgsql-general by date:

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