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

2010-07-13 Thread Adrian Klaver
On 07/13/2010 09:27 AM, Andrew Falanga wrote: On Jul 13, 9:12 am, adrian.kla...@gmail.com (Adrian Klaver) wrote: Thank you both for you help. I look forward to accessing the table tonight when I get home. For my own sake, would there happen to be any documentation on-line that I could read

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

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

2010-07-13 Thread Adrian Klaver
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 column "Stone.id" CREATE TABLE > test=*# \d Stone > Did not find any relation named "

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

2010-07-12 Thread A. Kretschmer
In response to 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?