----- Original Message ---- From: Tom Lane <tgl@sss.pgh.pa.us> To: Peter Eisentraut <peter_e@gmx.net> Cc: pgsql-sql@postgresql.org Sent: Tuesday, July 10, 2007 9:15:20 PM Subject: Re: [SQL] Database system identifier from SQL
Peter Eisentraut <peter_e@gmx.net> writes: > Tom Lane wrote: >> Peter Eisentraut <peter_e@gmx.net> writes: >>> Is there a way to query the database system identifier that >>> pg_controldata outputs from SQL? >> >> Don't think so. Do you have a use-case for providing a function to >> return that?
> I'd like to find out whether two connections are really to the same > server.
Hmm. Seems a bit of an odd case, but on the other hand there might be applications for it in connection with management of backups and WAL-shipping and so forth. I have no objection to adding a function.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at