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:[EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
