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

Karam,

try \? to get answers to your questions.

Dave
On Wed, 2004-02-25 at 09:57, Karam Chand wrote:
> 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
>
--
Dave Cramer
519 939 0336
ICQ # 14675561