Re: [GENERAL] Why can't I see the definition of my relations

2010-07-13 Thread Andrew Falanga
On Jul 13, 9:12 am, adrian.kla...@gmail.com (Adrian Klaver) wrote: > On Monday 12 July 2010 10:18:07 pm A. Kretschmer wrote: > > > > > > > No, the reason is another: > > > test=# create table "Stone"(id serial); > > NOTICE:  CREATE TABLE will create implicit sequence "Stone_id_seq" for > > serial c

[GENERAL] Why can't I see the definition of my relations

2010-07-12 Thread Andrew Falanga
Hi, I just finished defining a couple of tables with PgAdmin III and I'm seeing something peculiar. I'm not sure what the problem is. When I connect to the DB using psql and do "\d " I get an error saying that there's not relations by that name. What? When I do, "\d" I see the tables listed.

Re: [GENERAL] How does psql actually implement the \d commands

2008-04-11 Thread Andrew Falanga
On Apr 11, 5:45 am, [EMAIL PROTECTED] ("Albe Laurenz") wrote: > > Format the output. > > For example, the "17408" in the query above is a result from the > first query. > > If you had triggers, constraints, rules or indexes associated > with the table or the table would INHERIT another table, you'd

Re: [GENERAL] How does psql actually implement the \d commands

2008-04-11 Thread Andrew Falanga
On Apr 9, 5:51 am, [EMAIL PROTECTED] ("Albe Laurenz") wrote: > Andrew Falanga wrote: > > > I know about the -E option to psql and did that to get the following, > > which is what psql does for a \d : > > > * QUERY ** > > SELECT c.oid

[GENERAL] How does psql actually implement the \d commands

2008-04-09 Thread Andrew Falanga
Hi, I know about the -E option to psql and did that to get the following, which is what psql does for a \d : * QUERY ** SELECT c.oid, n.nspname, c.relname FROM pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace WHERE pg_catalog.pg_table_is