Get a book from the library on the use of SQL - the creation of tables in
postgreSQL is the same as creating a table in any other variant of SQL (as
far as I know, only used a few). In postgreSQL
%createdb mydatabase
PostgreSQL as well as mySQL both come with documentation including how to do
these things (/usr/share/doc/postgresql-vNo or /usr/share/doc/MySQL-vNo).
Population of tables is the same - get the afore-mentioned book from the
library or check through the docs that came with the installation - create
tables in the database then populate them with data.
%CREATE TABLE names (
firstName varchar(10),
lastName varchar(15),
etc
);
%INSERT INTO names
VALUES ('Mickey', 'Mouse', etc);
Lastly, I suspect that the fourth query is the key one. There ARE add-on
packages which add a gui to different variants of SQL but unless you have
installed one then you are going to be using command line instructions to
create, populate and manipulate your tables.
Daryl Johnson
Proplan Associates
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of AOL Systems
> Sent: 14 July 2001 05:02
> To: [EMAIL PROTECTED]
> Subject: [newbie] Pls help me!
>
>
> To whom it may concern
>
> I just want to know something about postgreSQL
>
> 1. how to create tables?
> 2.how to populate tables?
> 3.where to get resources aside from postgreSQL.com,.org,.net
> 4.how to see the GUI side of it i really cannot find the GUI of Postgre?
>
>
>
>
> Thanks i hope someone answers it.
>
> thanks and God Bless!
>
> Respectfully
> AOL
>
>
>
>
>
