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: