Skip site navigation (1) Skip section navigation (2)

Re: query builder / system objects

From: efesar <efesar(at)nmia(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: query builder / system objects
Date: 2003-03-04 00:19:02
Message-ID: NGBBKFMOILMAGDABPFEGAEINDMAA.efesar@nmia.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
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(at)nmia(dot)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


In response to

pgadmin-hackers by date

Next:From: Dave PageDate: 2003-03-04 08:55:59
Subject: Re: query builder / system objects
Previous:From: efesarDate: 2003-03-04 00:17:38
Subject: query builder / system objects

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group