Hi folks, hope you're doing well. I am searching for
DB - Vpostgres - SQL
· Simple query to view all contents in a table .
· Simple query to insert data into table row .
· Simple query to delete a row in table .
Many thanks in Advance
First, access or modification to the vPostgres databases of VMware appliances is not supported and should never take place without involving the GSS.
But vPostgres is just a normal PostgreSQL database and therefore all PostgreSQL commands for versions 9 and 10 are available.
For example:
https://www.postgresql.org/docs/9.6/docguide.html
https://www.postgresql.org/docs/10/index.html
messing about in the vCenter postgresql db is NOT supported by VMware and unless you have been directed by VMware to do so, you run the risk of being told your environment is unsupported.
if you want to learn PSQL I suggest you build a VM with it on and forget that vCenter is now running on Postgresql.
To further reinforce what the other vExperts have said, if you're asking this in context of poking around in the vCenter database, DO NOT do that. If you need to access the data within, you need to learn to use the API via one of many methods. Stay out of the vCenter database.
To phrase it in William Lam's words:
https://www.virtuallyghetto.com/2014/03/a-kitten-dies-every-time-you-query-the-vcdb.html