Skip site navigation (1) Skip section navigation (2)

Postgres and Oracle differences and questions

From: "D(dot) Johnson" <dspectra(at)home(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Postgres and Oracle differences and questions
Date: 2001-02-03 12:25:05
Message-ID: 3A7BF8A1.57EBABD7@home.com (view raw or flat)
Thread:
Lists: pgsql-interfaces
I have recently been working on several projects that use MSAccess as a
front end to both a Postgres and Oracle DB. Unfortunately, I have
noticed some differences and limitations in Oracle that seem to make
Postgres look like a better choice for the application. My problem is
with the block sizing differences in PG and Oracle. It seems that when
mapping memo types from Access to Postgres you could create a text type
in Postgres that emulates the Access memo type, and you could define a
table with any number of these types of fields. In Oracle you can only
have one memo field mapped to a table with a max size equal I believe to
the block size, and if you use the max block size then you cannot define
any other fields in the same table.

I am curious how Postgres handles text types, is a var char or does it
allocate the full 8K for the text type. In Oracle, the size of the table
definition has to be within the block boundary, is the same restriction
true in Postgres.

D. Johnson
Spectra Data Systems Inc


Responses

pgsql-interfaces by date

Next:From: v jDate: 2001-02-05 09:44:07
Subject: Re: [INTERFACES] JDBC APPLET Problem
Previous:From: D. JohnsonDate: 2001-02-03 12:08:29
Subject: MSAccess memo types in Postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group