On Wed, 20 Jan 1999, Mike Bilow wrote:
>
>
> Karl F. Larsen wrote in a message to Mike Bilow:
>
> KFL> I'm wondering if ANYONE has used the posgress data base?
>
> Yes, Postgres works fairly well, but this is way off-topic here.
>
> Postgres has its own home page: "http://postgresql.nextpath.com/"
I can tie this to CLX the DX Cluster that for some reason uses
postgres as it's data base.
>
> KFL> I found there is a posgres login and so I can su -
> KFL> postgres and I will be in that login. I did a "createdb
> KFL> mydb" and it worked. Then I used psql mydb and that worked.
> KFL> Then I saw that destroydb mydb works fine.
>
> Don't use "su" to do this, since it will only do limited shell set up for the
> new user rather than a full login set up. Some scripts are omitted when the
> shell is other than a first-level shell, as documented.
>
Interesting. The way I use X is to start it as root and then su
the other xterm windows to user logins. They SEEEM to work fine Mike. I
can cut and paste between windows and such. I have not thought of another
way to do it.
> KFL> I now have postgres open in an nxterm window by itself
> KFL> and want to enter a data base which is an ascii phone number
> KFL> name address list. But there is no way to do this. The book
> KFL> stops here and goes off talking about SQL and without any
> KFL> explanation.
>
Since then I have run the tutorial and it's clear the "psql" Front
End is good enough to learn with. I have read in files with SQL calls on
it and it works fine.
Reading the admin web page I found out how to make a user a
postgres user and now do it all as login karl.
>
> The Postgres documentation assumes you have a knowledge of SQL, or "Structured
> Query Language," a loosely standardized (or, rather, widely vendor-enhanced)
> syntax for manipulating databases. SQL has become the universal standard for
> this kind of work, and there are many people who earn a good living from SQL.
Buying "The Practical SQL Handbook" for $31.00 and hope to soon
now how to spell SQL...:-)
> Furthermore, Postgres is a server engine, comparable to Oracle, Informix,
> Sybase, or some other commercial SQL engine. This means that you have to write
> client code that communicates with it, using one of many of the supported
> languages such as Perl or C. If you are not prepared to do this kind of
> programming, then forget Postgres and any other SQL engine.
I do a little C so I'm willing to try this task. Time will tell
how difficult it is.
>
> -- Mike
Thanks for your thoughts Mike and as usual they are right. Let you
know when I get a front end that makes a good Ham Radio logging system.
Best wishes
- Karl F. Larsen, 3310 East Street, Las Cruces,NM (505) 524-3303 -
