This ability to use ODBC with access is pure magic!
I created a database on the Access machine, and in that I created a table, with
a memo field.
I exported the table to the postgres database.
I looked at the structure of the table in pgsql, and the memo filed is type
TEXT of var length. As it sa
>
> I know I've read this is the docs but I can't find it now that I need it.
>
> What's the max length of a field name.
31 characters.
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PROTECTED]| (610) 853-3000
+ If your life is a hard drive,
Hmmm. Just gave all permisions to user, and created a NEW table database in
Access, and it imported the new permissions.
It seems that Access imports the permissions, and then doesn't let you chang
them, even when they have been changed in the pgsql system.
not a bad idea I usppose.
Now to work
Hello,
I'm trying to run postgres on two different post 5432 and port 5433 with
different data directories for each instance:
[ -x /usr/local/pgsql/bin/postmaster ] && {
su -l postgres -c '/usr/local/pgsql/bin/postmaster -S -i'
echo -n ' pgsql'
}
[ -x /usr/local/pgsql/bin/post
I have two databases here, and I can read both with Access. However, I can only
write to one with Access, the second one, although it appears to be set up the
same - I think - I can't write to it to add records. Access shows the [Insert
Record] field as greyd out?
Any clues anyone?
ta
bob
--
ht
I know I've read this is the docs but I can't find it now that I need it.
What's the max length of a field name.
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson138 Cardwell Hall Manhattan, Ks 66506785-532-0561
Kansas State University
> Postgresql seems to offer me everything I'd need for the departmental
> work, and I find myself wondering if the only reason for my keeping Oracle
> around is to make the old resume look better. So
>
> Why keep Oracle? Why switch to postgresql?
>
> I'd really appreciate peoples thoughts o
Hello,
I didn't find a clear answer skimming throught the archives so I'll ask.
I currently have a running copy of Oracle 8 on our network. The
university has a site license for it, so I set one up for our department
approx. 6 months ago with the intention of migrating alot of our work onto
it
What are the limits of the TEXT data type in PostgreSQL 6.3.2? I have some
fairly large memos currently in msaccess that I'd like to pull into
postgres (I'm going to convert the entire database into postgres). Some of
our existing memo fields literally have a few pages (ok, generic term, but
From: Randy Dees <[EMAIL PROTECTED]>
Subject:Access database from PostgreSQL?
I have just read the wonderful concise directions for accessing a
PostgreSQL database from MS Access, and just wondered: does anyone have a
procedure for accessing the Access database from Postgres? I'm no
10 matches
Mail list logo
