Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Provide list of subscriptions and publications inpsql's completion - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] Provide list of subscriptions and publications inpsql's completion
Date
Msg-id acca64e9-f597-05a4-bb1f-b21a2f0d4a34@2ndquadrant.com
Whole thread Raw
In response to [HACKERS] Provide list of subscriptions and publications in psql's completion  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [HACKERS] Provide list of subscriptions and publications inpsql's completion  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
Tree view 
On 2/2/17 12:48 AM, Michael Paquier wrote:
> +#define Query_for_list_of_subscriptions \
> +" SELECT pg_catalog.quote_ident(subname) "\
> +"   FROM pg_catalog.pg_subscription "\
> +"  WHERE substring(pg_catalog.quote_ident(subname),1,%d)='%s'"

This query should also be qualified by current database.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [HACKERS] Provide list of subscriptions and publications inpsql's completion
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] pageinspect: Hash index support