Re: how to see how the data is structured in postgreqsql

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
> ------------------------------------------------------------------
>

In response to

Browse pgsql-general by date

  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