Re: [ADMIN] seeing tables across databases

2004-07-09 Thread Marie G. Tuite
--- 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

[ADMIN] object creation date

2003-09-12 Thread Marie G. Tuite
How can I identify table creation date as opposed to last modified? Thanks. -Marie ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [ADMIN] AutoIncrement not working

2002-11-07 Thread Marie G. Tuite
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