 | |
Postgresql for Dummies?
comp.databases.postgresql.novice comp.databases.postgresql.novice
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: possible to access a Linux box db from a Windows box via a GUI? -
10-16-2004
, 07:51 PM
|
Look at pgadmin III (http://www.pgadmin.org/pgadmin3/index.php). Sean On Oct 12, 2004, at 3:56 PM, Daniel Lerch wrote: It occured to me that I might have an easier time learning PostgreSQL if I start off with a GUI instead of just command line. But I access the database over our LAN -- I'm on a Windows 2000 box, and the psql database is on a Linux box. I've been accessing it by running PuTTY. So, my question is - is there a GUI program I can run off my Windows 2000 box that will allow me to access myt psql database on the Linux box? Or do I have no choice but run the GUI on the Linux box? Thanks, -d ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend |
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
#22
| |||
| |||
|
gsql-novice-owner (AT) postgresql (DOT) org] On Behalf Of Nikki|
I need to learn how to work with PostgreSQL for work, but I am *completely* unfamiliar with the program, almost completely unfamiliar with databases (I've only worked with very basic databases in MS Access), and relateively unfamiliar with using non-GUI programs. In other words, I need a 'Postgresql for Dummies' book - something that will start at the most basic level. The books I've seen out there on Amazon.com and other places all seem to be aimed at developers, though. Where can I go to get a basic, basic, BASIC tutorial/guidebook for learning PostgreSQL? Thanks, Daniel Lerch Portland, Oregon Hi Daniel |
I'm a recent starter, and have the O'Reilly 'Practical Postgresql'.
However, I must say I found that a daunting task to start with. So my
advice would be: Get the book, beause you're going to need it, but
don't start with it; it'll come into its own when you're using it as a
reference. So first, check the postgresql site documentation, and look
out for tutorials, AND go googling for other postgresql tutorials. That
go me started, because it is EXTREMELY easy to get started - it's just
that the books don't make it look easy! The complexity is in getting
the data out and 'operating' on it! It's really easy to set up a
database and get data into it.
I'll say that I am reasonably familiar with command line work, as a
Linux user. If you need that, it may be a good idea to get used to that
without tyring to learn postgresql at the same time.
If you were a Dummy, you wouldn't be choosing to use postgresql!
Good Luck, and Holler again if you need good solid amateur advice in
plain English.
Nikki
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if
your
joining column's datatypes do not match
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.