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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
