Re: maximum size - Mailing list pgsql-general

On Wed, 2005-02-23 at 08:34, Molinet Sylviane wrote:
> Hello,
>
> could you be so kind to help me with following requests ?
>
> I need the maximum size of the following types :
> varchar(n)

~ 1 Meg

> numeric(n,p)

no limit (actually ~ 1 Gig)

> text

~ 1 Gig

> bytea

~ 1 Gig

> Could you please give me the name of articles or publications and where I
> can find it for these requests ?

http://www.postgresql.org/docs/8.0/static/datatype.html#DATATYPE-NUMERIC
http://www.postgresql.org/files/documentation/faqs/FAQ.html


> I want to transfer a oracle database 8i to postgreSQL 7.3.2. Is there an
> article or publication which related about this ?

There's a contrib directory I've never used that supposed to help.

I'd recommend using at LEAST the latest version of 7.3, but preferably
8.0.1 or 7.4.7 (or whatever the latest releases of those versions are
today.)