Thread: tables & retrieving their names
Dears,I'm newbie in pgsql. I have a few question: 1.I need to use command of MySQL in pgsql. 2.How i see name of my tables in shell? 3.How i see name of my DBs in shell? 4.How i retrieve tables's name in C? 5.How i retrieve DBs's name in C? Yours,Mohsen.
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/