| From: | Adam Ruth <adamruth(at)mac(dot)com> |
|---|---|
| To: | pal kar <palkar0504(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: hi |
| Date: | 2009-05-04 20:57:58 |
| Message-ID: | 16506688-8594-440B-A7A2-A9BAF63A8EB7@mac.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
You can start with the information_schema tables, most databases have
them so it's probably best to learn them first. After that you can
delve into the pg_* tables, if you need something not in the
information_schema tables. Here's a link to some info.
http://www.alberton.info/postgresql_meta_info.html
On 05/05/2009, at 6:52 AM, pal kar wrote:
> Hi everyone !
>
> I am supposed to get the properties of
> each column of each table in a database
> of postgresql.
>
> I know querying the tables of a database
> for values inside them. But not how to
> get the information about the tables themselves.
> This is new for me.
>
> Can someone extend their help please ?
>
>
> Pal
| From | Date | Subject | |
|---|---|---|---|
| Next Message | JORGE MALDONADO | 2009-05-04 22:21:49 | DATA TYPE CONVERTION |
| Previous Message | pal kar | 2009-05-04 20:52:23 | hi |