Thread: Postgres tutorial examples !

Postgres tutorial examples !

From
Naceur
Date:
Dear Postgres Users,

I am new to Postgres. I succeded to install Postgres on my Linux -PC. It

is working and
I learning a lot from the html documentations.
However I did not find exemples or a samples of databas, query....
with the distribution I have (6.4.2)
In the tutorial they said that I will find examples under
'/usr/local/pgsql/src/tutorial/'
or some where else where pgsql is installed

So could any one of you help me to get or point to me where (web or ...)

Ican find this
the src/tutorial examples this would encourages me to get started.

I find the Postgres doc and mechanism very nice and understandable . So
It would be great from
you to help me get started

Thank you very much
Naceur






Re: [GENERAL] Postgres tutorial examples !

From
Gilles Darold
Date:
Hi Naceur,

As you say all existing samples to proceed with PostgreSQL is in the
documentation.
In this documentation you can learn how to query the database with SQL
request and
of course how to create a database. You also have in the programmer's guide
how to
connect and interact with the database engine with an application written in
C. Create
table and SQL query can be found in the user guide. For me I never read the
Tutorial
but I have seen that there is all to create a database, create table and
query it. (Table
in postgresql langage is named Class)

If you want to use other language like perl it's really the same way to
proceed. Just
download or generate the documentation of this langage/PostgreSQL interface
and you
will find all you want. The better way for Perl programming is to use DBI
and DBD::Pg

With this, in one hour you can create your own sample :-)

Hope this help...