Re: query builder / system objects

correction

relowner > 1 instead of >=1

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

-----Original Message-----
From: efesar [mailto:efesar@nmia.com]
Sent: Monday, March 03, 2003 5:18 PM
To: pgadmin-hackers
Subject: query builder / system objects



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