maximum size

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)
numeric(n,p)
text
bytea

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

Well, the manuals would be a good source of information for this. Go to
the website, and click "Documentation". There is a list of manuals on
the right-hand side. A good place to start is
http://www.postgresql.org/docs/8.0/static/datatype.html

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

http://techdocs.postgresql.org/ is a good place to start. Also, check
the mailing list archives for specific points.

Oh, there is a French-language community site too at:
http://www.postgresqlfr.org/
One of their news stories concerns a company moving from Oracle to
PostgreSQL too.

HTH
--
Richard Huxton
Archonet Ltd

On Wed, 2005-02-23 at 15:34 +0100, 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)
numeric(n,p)
text
bytea

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

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

Out of curiosity, why are you transferring to such an old version of
postgresql instead of 8.0?

Sven

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.)