Re: Newbie to pgadmin - Mailing list pgadmin-support

From Andreas Pflug
Subject Re: Newbie to pgadmin
Date
Msg-id 3FC7754D.6060505@pse-consulting.de
Whole thread Raw
In response to Newbie to pgadmin  (Miguel González Castaños <mgc@tid.es>)
List pgadmin-support
Miguel González Castaños wrote:

>Dear all,
>
> I am a newbie using PgAdmin, I got back to work with PostgreSQL, the
>last time I used PostgreSQL for a project PostgreSQL was around version
>7.1.x something (It was two years ago...).
>
> Now I am using version 7.3.4 and my colleagues asked for a nice-easy
>gui admin tool under windows 2000 for designing databases and inserting
>data on them.
>
> I searched on the postgresql web site, and I found pgadmin III. It
>seems like it is what We need, but having a quick look into it, we have
>seen:
>
>[+] As In the Introduction and Concepts book from Bruce Monjiam
>suggests, We use serial number instead of OIDs. If OIDs are not used in
>the tables, then There is no way to add rows in the edit grid...At least
>I havent found the way...
>  
>
You're probably missing a primary key on that table.

>[+] There is any case ( I have been able to reproduce it again) where
>pgadmin III required to use public."test" name for a table instead of
>the name test. I still do not know why, as I have said, I havent been
>able to reproduce it again
>  
>
Unknown... please specify if you locate a problem.

>[+] For that reason Someone suggested to use pgaccess, which seems that
>has a way of doing so. This tool seems to be much easier, but also more
>limited that pgadmin III, though. So in the end, I have suggested to use
>PgAdmin III for designing the database and PgAccess for inserting the
>data. I dont know if It would be easy or not to have a look into the
>pgaccess code and share some source code...(although are not coded in
>the same computer language ?)
>  
>
You certainly may use different tools if you like, but you should be 
able to enter all data using the grid if oid or pk is present.


>[+] Apart of that I see in the ToDo list that the backup/restore option
>will appear soon...Is that related with the export data dialog, isnt it?
>  
>
No, export is a user friendly export format, backup/restore is for admin 
purposes (gui for pg_dump/pg_restore)

>[+] I am a native Spanish speaker (quite obvious from my mistakes
>writing English), if any help is needed (even coding something) I could
>give a hand...Anyway I would like to comment that in the Sequences, the
>word chosen is "Sequencias" and in Spanish is "Secuencias"...just a
>small typo...
>  
>
Fixed,
You're invited to review *all* spanish translations, just as any other 
language should be reviewed by a person different from the original 
translator. You just don't see your own typos...

Regards,
Andreas



pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Newbie to pgadmin
Next
From: Miguel González Castaños
Date:
Subject: Re: Newbie to pgadmin