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
-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
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
: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
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
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
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
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
: [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
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
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
11 matches
Mail list logo