Thread: A simple SQL command
Hello, How could i know the name of all the table in my database and, if possible, their prototype. I would like a SQL command if possible -- Edouard DESSIOUX Proverbe chien : "Si ca se mange pas, Si ca se baise pas, Pisse dessus !!"
On Wed, 27 Oct 1999, Edouard DESSIOUX wrote: > How could i know the name of all the table in my database > and, if possible, their prototype. > I would like a SQL command if possible From within psql, enter \dt. It's not an SQL command though. To look at the "prototype", as you say, enter \d tablename. -- Peter Eisentraut Sernanders vaeg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden
Select tablename from pg_tables. Sincerely yours, Yury. don.web-page.net, ICQ 11831432 ----- �������� ��������� ----- ��: Edouard DESSIOUX <edx@intrinsec.com> ����: <pgsql-general@postgreSQL.org> ����������: 27 ������� 1999 �. 14:10 ����: [GENERAL] A simple SQL command > Hello, > > How could i know the name of all the table in my database > and, if possible, their prototype. > I would like a SQL command if possible