From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: Want some basic compare of data type on PostgreSQL and MySQL
Date: 1 Sep 2011 11:22:36 GMT
Message-ID: <j3npts$e8n$2@reversiblemaps.ath.cx> (raw)
References: <1314854108076-4757149.post@n5.nabble.com>
On 2011-09-01, bhavesh1385 <bhavesh.bece.13@gmail.com> wrote:
> Hello All,
>
> I Want some basic compare of data type on PostgreSQL and MySQL.
>
> [1] How to make Primary Key as a Auto Increment...?
you can't, use the pseudo-type serial (or bigserial) instead
which does something similar, but subtly different.
> [2] Suppose I want to put 'ENUM' data type then how i can do that ..?
I think you have to create an enum type first.
> [3] Please suggest me basic Data type Comparesion between PostgreSQL and
> MySQL .. like :-
>
> PostgreSQL MySQL
> ---------------------------------------------
> characte varying VARCHAR
> integer INT
postgres understands varchar and int as well as aliases fior the
expected types
> like that i want all the possible data type comparision.
assuming you understand mysql types already:
http://www.postgresql.org/docs/9.0/interactive/datatype.html
--
⚂⚃ 100% natural
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasen@xnet.co.nz
Subject: Re: Want some basic compare of data type on PostgreSQL and MySQL
In-Reply-To: <j3npts$e8n$2@reversiblemaps.ath.cx>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox