Re: Database system identifier via SELECT?

On 12/08/2011 12:57 PM, Bruce Momjian wrote:
>
> Chris Redekop wrote:
>> Is there any way to get the database system identifier via a select
>> statement?  I have a primary/secondary async replication setup, and I'd
>> like be able to verify from the client side that the provided primary and
>> secondary connection strings do in fact refer to the same data set...
>
> Wow, that is a reasonable thing to want available via SQL, but I can't
> see a way to get to it.
>
> The only method I can suggest is to write a server-side C function that
> calls GetSystemIdentifier().

This seems like something we should have in core, don't you think?

JD

>


--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
The PostgreSQL Conference - http://www.postgresqlconference.org/
@cmdpromptinc - @postgresconf - 509-416-6579