pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: W. van den Akker <wvdakker@wilsoft.nl>
To: Aage J. Skjolingstad <aages@aajs.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] ODBC
Date: Sat, 4 Mar 2000 10:30:11 +0100
Message-ID: <004201bf85bc$3d2c9120$0500020a@wilsoft.nl> (raw)
References: <001a01bf85b5$cd5d45c0$0500020a@wilsoft.nl>
	<38C0D37F.E443558D@aajs.com>

Initally I've done that too, but I have to convert several databases.

PostgreSQL does support longvar fields for string longer that 255, does it??

Willem

----- Original Message -----
From: Aage J. Skjolingstad <aages@aajs.com>
To: W. van den Akker <wvdakker@wilsoft.nl>
Sent: Saturday, March 04, 2000 10:12 AM
Subject: Re: [INTERFACES] ODBC


> Hi,
>
> I had a similar problem and chose to change all my capital letters to
> lower case prior to converting from Access, ---- It finally made my
> life easier after doing so.
> (and field sizes max 255)
>
> Good Luck
>
> Aage
>
> > "W. van den Akker" wrote:
> >
> > Hi,
> >
> > I've some (only one actually) problems with the conversion
> > from Access to PostgreSQL. The table and columnnames
> > of the Access database do have sometimes capitals (ThisTable,
> > ThisColumn).
> > If I convert this table or row, the table and row are created but I
> > cann't
> > access them. It lookes like the postgress engine converts
> > automaticly all
> > names to lowercase. If a table is created the conversion to
> > lowercases
> > doesn't occur.
> >
> > Am I doing something wrong, or need the postgress ODBC-driver be
> > changed?
> >
> > TIA
> >
> > Willem
>




view thread (48+ messages)  latest in thread

Message-ID: <004201bf85bc$3d2c9120$0500020a@wilsoft.nl>
Permalink:  ../004201bf85bc$3d2c9120$0500020a@wilsoft.nl/
Also on:    postgresql.org/message-id/004201bf85bc$3d2c9120$0500020a@wilsoft.nl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: wvdakker@wilsoft.nl, aages@aajs.com
  Subject: Re: [INTERFACES] ODBC
  In-Reply-To: <004201bf85bc$3d2c9120$0500020a@wilsoft.nl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox