Is there a better way to query a database definition than select from
pg_catalog tables and views? For example, when I put out a new
software update, I need to verify that all the table, column,
constraint, etc definitions are correct for the update.
Thanks,
Bob
--
Sent via pgsql-general
On Aug 26, 2008, at 10:22 AM, Scott Marlowe wrote:
On Tue, Aug 26, 2008 at 12:10 AM, Phoenix Kiula <[EMAIL PROTECTED]
> wrote:
On 8/26/08, Scott Marlowe <[EMAIL PROTECTED]> wrote:
Slony replication lets postgresql accomplish this, which is really
quite impressive. We just upgraded from an 8
On Aug 21, 2008, at 6:21 AM, Merlin Moncure wrote:
You can always pass the order by clause (or hardcode it) into the
execute statement. Also if you are using 8.3 you may want to check
out to the new improvements to 'execute'...using.
Hi Merlin,
I can't use an order by on the execute, because
Is it possible to sort a result set in plpgsql?
That is, after building up the result set with RETURN NEXT from
multiple queries, I'd like to sort the set before returning.
I'm still using 8.1 if that is an issue.
Thanks,
Bob Gobeille
Hewlett Packard
Open Source Program Office
--
Sent via
On Posgresql 8.1, debian
I have turned on stats collection:
stats_start_collector = on
stats_command_string = on
stats_block_level = on
stats_row_level = on
stats_reset_on_server_start = on
and am collecting system stats (eg. pg_statio_sys_tables). This is
great.
select count(*) from pg_st
