From: Jehan-Guillaume (i. de R. <io...@fr...> - 2012-09-17 08:11:05
|
On 17/09/2012 09:55, eye...@gm... wrote: > The following data was submitted on 2012/09/17 07:55. > > ====== E-mail ====== > > Name > Panos Katertziadis > PostgreSQL ver. > 8.4.13 > phpPgAdmin ver. > 5.0.4 > Comments > Hello. I wish that phpPGadmin would "spit out" the sql it uses for perfoming tasks like creation of a table (or anything else). I just migrated from mySQL and phpMYadmin (which has the feature) and i think that such "spitting" can certainly aid to better understanding of the PostgreSQL idiosyncracies. If the feature is already available, please point me to it. Kind Regards, Panos. Hello, this feature is not available and would require a lot of work in PPA. However, it's been a while I am thinking about refactoring some parts of PPA that would maker this easier to accomplish. Anyway, if you want to learn more about PostgreSQL SQL syntaxe, it's simple: it follows the official SQL specs. You can also use "\h SQL COMMAND" (ie. \h ALTER TABLE) in psql, or just check the PostgreSQL doc which is really good. Cheers, |