how to sort alphabetically in openoffice writer

The “public” table list appeared and I clicked on the + sign to expand the list of public tables. It assumed the “localhost” hostname and database named after the user. Since my prototype PostgreSQL database, named rreilly, was on my local machine, I just left the Data Source URL blank. If you connect to a corporate PostgreSQL server, you could name it something else, like corp-pgsql. I was running the PostgreSQL server on my laptop with a hostname of curley (192.168.2.40) so I named the datasource curley-pgsql.

Selected New Data Source (on the left hand side of the Data Source Administration window).

Clicked on the Tools menu and selected Data Sources.

Started and brought up a new text document.

Here are the steps I used set up my PostgreSQL datasource. The PostgreSQL driver works great once you get it installed. Once the driver file was installed properly, I could select the PostgreSQL type datasource in the datasources window.Ĭonnecting with ’s datasource screens Pkgchk comes bundled with and is their plug-in packaging system. Since I was just setting it up for myself (on my laptop), I put the file in the 1.1.2/user/uno_packages directory and ran the pkgchk program. The only problem I had during installation was that I had to search to find the pkgchk command. I used 1.1.x/user/uno_packages, but 1.1.x/share/uno_packages might also be appropriate for multiple users. zip file (without unzipping) into the right place. I downloaded the PostgreSQL driver zip file from the site. Getting to talk to PostgreSQL databases was straightforward. You can apply the same procedure for Calc. I’ll cover connecting with the word processor, using a PostgreSQL database that I had on my laptop. You’ll be able to connect with both Writer and Calc.

Setting up the connection is pretty easy: just download the driver and configure a few things. I’m sure you can think of many other uses for such a connection. With Writer, and a connection to your PostgreSQL database, you can do just that for each customer. Did you know that you can connect the office suite to a PostgreSQL database? Maybe your database contains valuable customer or inventory information that your staff could use to generate a personalized sales letter.

How to sort alphabetically in openoffice writer