Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-30 Thread Rich Shepard
On Fri, 30 Sep 2011, Vincent Veyron wrote: You get a lot more : this gives you an interface to Postgresql inside an Emacs buffer. Thank you. Rich -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/p

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-30 Thread Vincent Veyron
Le mercredi 28 septembre 2011 à 06:07 -0700, Rich Shepard a écrit : > On Wed, 28 Sep 2011, Vincent Veyron wrote: > > > I'm not sure what 'INSTALL INTO ... statements' are, but are you aware > > of the very convenient 'M-x sql-postgres' in emacs? > > Vincent, > >I have a SQL major mode for em

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-28 Thread Rich Shepard
On Wed, 28 Sep 2011, Vincent Veyron wrote: I'm not sure what 'INSTALL INTO ... statements' are, but are you aware of the very convenient 'M-x sql-postgres' in emacs? Vincent, I have a SQL major mode for emacs. Don't know that it's specific to postgres but it is automatically invoked when I

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-28 Thread Vincent Veyron
Le mardi 27 septembre 2011 à 13:19 -0700, Rich Shepard a écrit : > On Tue, 27 Sep 2011, John R Pierce wrote: > > > 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 = Po

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-27 Thread Rich Shepard
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 con

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-27 Thread John R Pierce
On 09/27/11 11:20 AM, Rich Shepard wrote: All my postgresql databases are in /usr/local/pgsql/data/base/ in numbered subdirectories. I've no idea in which one resides the database I want. Is there a way to determine where my database is located? Eeek! you NEVER directly access the postg

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-27 Thread Richard Broersma
You will need to use the PostgreSQL ODBC driver. I should mention that I haven't used ODBC from a Linux client before. I found the some instructions in the mailing list archive: http://archives.postgresql.org/pgsql-odbc/2002-02/msg00023.php On Tue, Sep 27, 2011 at 11:20 AM, Rich Shepard wrote:

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-27 Thread Rich Shepard
On Tue, 27 Sep 2011, Richard Broersma wrote: ODBC handles this by converting these to a text representation that Open Office can handle. Richard, Progress has been made. I built and installed unixODBC from slackbuilds.org and now the hangup is identifying the location and name of the databa

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-27 Thread Rich Shepard
On Tue, 27 Sep 2011, Richard Broersma wrote: I'd recommend using JDBC ODBC driver for PostgreSQL. Open Office via direct JDBC has a hard time with some PostgreSQL data-types. ODBC handles this by converting these to a text representation that Open Office can handle. Richard, LibreOffice t

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-27 Thread Richard Broersma
On Tue, Sep 27, 2011 at 9:15 AM, Rich Shepard wrote: >  A Google search for 'libreoffice-sdbc-postgresql' actually turns up a link > that supposed to have a .txz version for Slackware, but the only packages on > the site are .deb. Oh, well. I'll keep looking. I'd recommend using JDBC ODBC driver

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-27 Thread Rich Shepard
On Mon, 26 Sep 2011, planas wrote: Which version of LO are you using and which Linux? I have some experience with using LO as a front-end when pgAdmin is not the best tool. LO-3.4.3 on Slackware-13.1/32-bit. I have noticed that with Ubuntu you need to use the 3.3.x series from the reposito

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-26 Thread planas
Rich On Mon, 2011-09-26 at 11:38 -0700, Rich Shepard wrote: > Rather than writing an application right now to enter data into a table I > thought of trying LibreOffice as a front end. But, it doesn't seem to work > as OO.o did. This leads to two questions: > >1) Can someone show me how to

Re: [GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-26 Thread Filip Rembiałkowski
2011/9/26 Rich Shepard > Rather than writing an application right now to enter data into a table I > thought of trying LibreOffice as a front end. But, it doesn't seem to work > as OO.o did. It does, albeit you will need libreoffice-base which is not always installed by default (not in my Ubun

[GENERAL] Quick-and-Dirty Data Entry with LibreOffice3?

2011-09-26 Thread Rich Shepard
Rather than writing an application right now to enter data into a table I thought of trying LibreOffice as a front end. But, it doesn't seem to work as OO.o did. This leads to two questions: 1) Can someone show me how to use LO as a front end to a postgres table? 2) Is there another tool