Re: Quick-and-Dirty Data Entry with LibreOffice3?

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