From: | "Lars Stenberg" <lars(dot)stenberg(at)psycat(dot)net> |
---|---|
To: | "Anil Amarakoon" <awc(at)drytel(dot)net> |
Cc: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: pg_class et el -little OT |
Date: | 2003-02-03 00:55:14 |
Message-ID: | 001b01c2cb1e$e9dc46e0$0301a8c0@ic3 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi!
I guess you can find an answer on:
http://developer.postgresql.org/docs/postgres/catalogs.html
Please tell me if you could =9
Mvh
Lars
----- Original Message -----
From: "Anil Amarakoon" <awc(at)drytel(dot)net>
To: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Monday, February 03, 2003 1:39 AM
Subject: [JDBC] pg_class et el -little OT
> Hi All;
>
> I just want query database and get the structures in in my application.
>
> If I run select * from pg_class where tableowner='myname';
> get all the tables tables created by me.
>
> Is there any other place that I can get file names and sequnces??
>
> like this
> select * from pg_table where tableName=role;
>
> will give you
>
> Id int
> roleName text etc..
>
> same kind of info for the sequence..
>
> Thank you in advance for any replies.
>
> awc
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-02-03 00:55:15 | Re: Coding style |
Previous Message | Anil Amarakoon | 2003-02-03 00:39:00 | pg_class et el -little OT |