--- Jodi Kanter <[EMAIL PROTECTED]> wrote:
> I am working with a colleague who is using postgres
> to create a number
> of databases. On his system when he views his tables
> (\d) he can see
> tables from other databases - not all of them but
> some. He cannot access
> them as the user he is sig
How can I identify table creation date as opposed to last modified?
Thanks.
-Marie
---(end of broadcast)---
TIP 8: explain analyze is your friend
The sequence needs to be reset:
select setval('datadef_datadefindex_seq',(select max(datadefindex) from
datadef));
This will do it for you.
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:pgsql-admin-owner@;postgresql.org]On Behalf Of Ben Kassel
> Sent: Monday, November 04, 2002