On Tue, 27 Sep 2011, John R Pierce wrote:
Eeek! you NEVER directly access the postgres data files. rather, you
connect to postgres via a socket, and ask it to fetch the data for you,
thats just how it works.
Well, when the LO odbc window asks for the location of the database to which
to connect, what do I tell it?
to use ODBC, you'd need to give it the DSN information, I don't know the
exact format, but in general, its something like
[PostgreSQL]
Description = Postgres Database FRED
Driver = PostgreSQL
Trace = Yes
TraceFile = sql.log
Database = FRED
Servername = localhost
UserName = fred
Password =
Port = 5432
I'm not presented with an opportunity to offer any of this information
anywhere.
Guess the most practical thing to do is give up trying to use LO as a
front end. I'll just write INSTALL INTO ... statements in emacs then use
psql to read them into the table.
Thanks all,
Rich
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
