From: | zhang zhengquan <zhang(dot)zhengquan(at)gmail(dot)com> |
---|---|
To: | rod(at)iol(dot)ie |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: how to see how the data is structured in postgreqsql |
Date: | 2009-03-31 16:28:03 |
Message-ID: | 128a87f00903310928y44314c4jf39f2b5e896611a6@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thank you so much Ray, I will give it a go.
Z
2009/3/31 Raymond O'Donnell <rod(at)iol(dot)ie>:
> On 31/03/2009 16:58, zhang zhengquan wrote:
>> I would like to know how the my log data is organized in the database
>> and then I will see if I can do something to optimize the data entry
>> into the db.
>
> pgAdmin is a really good tool that lets you see all the objects in your
> database in a tree view:
>
> www.pgadmin.org
>
>
> Alternatively, you could use \d at the psql command line.
>
> Ray.
>
>
> ------------------------------------------------------------------
> Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> rod(at)iol(dot)ie
> Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
> ------------------------------------------------------------------
>
From | Date | Subject | |
---|---|---|---|
Next Message | SHARMILA JOTHIRAJAH | 2009-03-31 16:31:42 | Re: Space for pg_dump |
Previous Message | Raymond O'Donnell | 2009-03-31 16:17:04 | Re: how to see how the data is structured in postgreqsql |