Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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



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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group