[ADMIN] Show tables query

2006-04-02 Thread Andy Shellam
Hi, Is there an SQL command supported by Postgres to return a list of tables in a database? For example on mySQL, you can connect to a database and issue the command SHOW TABLES to bring back a list of tables in that database. In PG this throws the error "unknown configuration parameter

Re: [ADMIN] Show tables query

2006-04-02 Thread Grega Bremec
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Andy Shellam wrote: | Hi, | | Is there an SQL command supported by Postgres to return a list of | tables in a database? | | For example on mySQL, you can connect to a database and issue the | command SHOW TABLES to bring back a list of tables in

Re: [ADMIN] Show tables query

2006-04-02 Thread Oleg Bartunov
On Sun, 2 Apr 2006, Grega Bremec wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Andy Shellam wrote: | Hi, | | Is there an SQL command supported by Postgres to return a list of | tables in a database? | | For example on mySQL, you can connect to a database and issue the | command

FW: [ADMIN] Show tables query

2006-04-02 Thread Andy Shellam
:34 am To: [EMAIL PROTECTED] Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Show tables query -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Andy Shellam wrote: | Hi, | | Is there an SQL command supported by Postgres to return a list of | tables in a database? | | For example on mySQL, you

Re: [ADMIN] Show tables query

2006-04-02 Thread Christopher Browne
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Andy Shellam) belched out: Is there an SQL command supported by Postgres to return a list of tables in a database? Yes, it's called SELECT. There is a standard schema called INFORMATION_SCHEMA, which contains a variety of relevant

Re: [ADMIN] Show tables query

2006-04-02 Thread Rajesh Kumar Mallah
On 4/2/06, Christopher Browne [EMAIL PROTECTED] wrote: After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Andy Shellam) belched out: Is there an SQL command supported by Postgres to return a list of tables in a database? Yes, it's called SELECT.There is a standard schema called

Re: [ADMIN] Show tables query

2006-04-02 Thread Andy Shellam
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Andy Shellam) belched out: Is there an SQL command supported by Postgres to return a list of tables in a database? Sorry, did I say something wrong? I thought it was a perfectly valid question actually. The application in mind is

Re: [ADMIN] Show tables query

2006-04-02 Thread Rajesh Kumar Mallah
On 4/2/06, Andy Shellam [EMAIL PROTECTED] wrote: After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Andy Shellam) belched out: Is there an SQL command supported by Postgres to return a list of tables in a database? Sorry, did I say something wrong? I thought it was a perfectly

Re: [ADMIN] Show tables query

2006-04-02 Thread Andy Shellam
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rajesh Kumar Mallah Sent: Sunday, 02 April, 2006 4:32 pm To: [EMAIL PROTECTED] Cc: Christopher Browne; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Show tables query On 4/2/06, Andy Shellam [EMAIL PROTECTED] wrote: After takin a swig o

Re: [ADMIN] Show tables query

2006-04-02 Thread Tom Lane
Rajesh Kumar Mallah [EMAIL PROTECTED] writes: information_schema is the standard which are more likely to behave the same in all versions of pgsql becoz they are(currently) views on the sys catalogs. Unfortunately, the SQL committee did tremendous damage to that argument by changing the

Re: [ADMIN] Show tables query

2006-04-02 Thread Peter Eisentraut
Tom Lane wrote: Unfortunately, the SQL committee did tremendous damage to that argument by changing the definitions of some of those views in SQL2003 :-( The only changes to existing views were one renamed column and two or three cases with relaxed permission checks so that more objects are