| 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: | Whole Thread | Raw Message | 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 |