query builder / system objects

From: efesar <efesar(at)nmia(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: query builder / system objects
Date: 2003-03-04 00:17:38
Message-ID: NGBBKFMOILMAGDABPFEGKEIMDMAA.efesar@nmia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers


dave,

pga3 question

i can tell system columns easily (and hopefully correctly):

// We need to know if we're going to show system objects
wxString sysobjstr;
if (!settings->GetShowSystemObjects())
sysobjstr = " WHERE attnum >= 0 ";

but is this an adequate way to check for system tables/views? this is what
i'm using now.

// We need to know if we're going to show system objects
wxString sysobjstr;
if (!settings->GetShowSystemObjects())
sysobjstr = " AND relowner >= 1 ";

the other way i was going to do it was if the first three letters are "PG_"
but maybe you have a more correct way of doing this.

-keith

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message efesar 2003-03-04 00:19:02 Re: query builder / system objects
Previous Message Dave Page 2003-03-03 20:53:25 Re: add const/enumarate in crtpgAppClass.vbs