Peter Eisentraut <[EMAIL PROTECTED]> writes:
> 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 w
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
"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 t
ssage-
From: [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:
>
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
> 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, 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 INFOR
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 releva
06 10: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
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 SHOW
-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
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
12 matches
Mail list logo