Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL

2011-09-01 Thread Scott Marlowe
On Thu, Sep 1, 2011 at 7:32 AM, Leif Biberg Kristensen wrote: > On Thursday 1. September 2011 11.16.23 Scott Marlowe wrote: >> The postgresql type text is a varchar with >> no precision that can hold up to about a gig or so of text.  Not that >> i recommend putting a gig of text into a single fiel

Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL

2011-09-01 Thread Leif Biberg Kristensen
On Thursday 1. September 2011 11.16.23 Scott Marlowe wrote: > The postgresql type text is a varchar with > no precision that can hold up to about a gig or so of text. Not that > i recommend putting a gig of text into a single field in a database. Printed out as plain text on paper with 4,000 char

Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL

2011-09-01 Thread Jasen Betts
On 2011-09-01, bhavesh1385 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] Suppo

Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL

2011-09-01 Thread Samuel Gendler
On Wed, Aug 31, 2011 at 10:15 PM, bhavesh1385 wrote: > Hello All, > > I Want some basic compare of data type on PostgreSQL and MySQL. > > I am Try to using create the database on PostgreSQL with the same query on > MySQL then it will create a problem... > > I have make changes according to the Dat

Re: [SQL] Want some basic compare of data type on PostgreSQL and MySQL

2011-09-01 Thread Scott Marlowe
On Wed, Aug 31, 2011 at 11:15 PM, bhavesh1385 wrote: > Hello All, > > I Want some basic compare of data type on PostgreSQL and MySQL. > > I am Try to using create the database on PostgreSQL with the same query on > MySQL then it will create a problem... > > I have make changes according to the Dat

[SQL] Want some basic compare of data type on PostgreSQL and MySQL

2011-08-31 Thread bhavesh1385
Hello All, I Want some basic compare of data type on PostgreSQL and MySQL. I am Try to using create the database on PostgreSQL with the same query on MySQL then it will create a problem... I have make changes according to the Datatype of PostgreSQL and below are the syntax for the query. Into M