Re: Moving from MySQL to PGSQL....some questions

In PGAdmin III -- you might want to UNCHECK the "Display system objects"
option under the "Display" menu option -- this will prevent you from seeing
all of the non-public schema's and limit your view in PGAdmin to just the
databases you created...

Most people dont really need to dink around with the system tables anyway...

As you probably noticed -- postgreSQL is a different beast than MS Access
and mySQL -- postgreSQL is a true RDBMS like Sybase, Orale, and SQL
Server... postgrSQL is a true 'client/server' RDBMS -- it does not contain
it's own GUI client like MS Access

postgreSQL is NOT just a high-powered version of MS Access or mySQL -- there
are quite a few differences --

Not to be rude -- but the postgreSQL docs (the Preface, Tutorial, and SQL
Language sections) would be good for you to read...

--
Greg Patnude / The Digital Demention
2916 East Upper Hayden Lake Road
Hayden Lake, ID 83835
(208) 762-0762

"Karam Chand" <karam_chand03(at)yahoo(dot)com> wrote in message
news:20040225145704(dot)40397(dot)qmail(at)web60804(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
> Hello
>
> I have been working with Access and MySQL for pretty
> long time. Very simple and able to perform their jobs.
> I dont need to start a flame anymore :)
>
> I have to work with PGSQL for my companies current
> project.
>
> I have been able to setup postgresql in my rh box and
> i can connect and work with psql. I even downloaded
> pgadmin III so that i can get to work with a GUI
> interface.
>
> As I starting...I see the architecture of PGSQL is
> quite complex...or thats what I feel....maybe its for
> good :) Here are some of my doubts :
>
> 1.) What is template1 and template0? I assume these
> are system databases. Am I right?
>
> 2.) When I create a database using CREATE DATABASE
> stmt. a new DB is created where it has 4 schemas and
> around 100 tables. These are the system tables keeping
> information about everything in the database? I hope I
> am correct :)
>
> 3.) To get all the database is the server we use query
> like -
>
> select datname from pg_database
>
> I means that there exists a table pg_database in all
> the database and all the pg_database table(s) are
> updated whenever a user issues CREATE DATABASE stmt.
>
> Why I am saying so coz in PgAdmin III i can see these
> tables in all the databases?
>
> 4.) I couldnot find any query to change the context of
> database like in MySQL :
>
> use database;
>
> or am i missing something?
>
> 5.) In MySQL, there are many command like show tables,
> show databases etc. to get object details. I cant see
> anything similar in PGSQL. After searching the net i
> find that i have to execute certain queries to fetch
> those queries. Is this the only way?
>
> Any help would be appreciated.
>
> Regards
> Karam
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail SpamGuard - Read only the mail you want.
> http://antispam.yahoo.com/tools
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>