Обсуждение: maximum size
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 ? Thanks MOLINET S.
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.)