Re: tables & retrieving their names

On Mon, Feb 21, 2005 at 03:45:42PM -0800, Mohsen Pahlevanzadeh wrote:

> 2.How i see name of my tables in shell?
> 3.How i see name of my DBs in shell?

See the psql documentation:

http://www.postgresql.org/docs/8.0/static/app-psql.html

See also "System Catalogs" and "The Information Schema":

http://www.postgresql.org/docs/8.0/static/catalogs.html
http://www.postgresql.org/docs/8.0/static/information-schema.html

> 4.How i retrieve tables's name in C?
> 5.How i retrieve DBs's name in C?

In addition to the above, see "libpq - C Library" in the documentation:

http://www.postgresql.org/docs/8.0/static/libpq.html

If you're new to PostgreSQL, it might be useful to go through the
Tutorial and then skim the rest of the documentation.  The FAQ might
also answer some of your questions.

http://www.postgresql.org/docs/

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/