On Tue, Mar 06, 2001 at 10:38:43AM -0500, Michael Fork wrote:
> try starting psql with the -E option -- this displays all queries used
> internally to the screen, i.e.:
Sorry, hadn't read this one before posting... Thanks to the "moderating" it'll
all be out of synch anyway but..
Patrick
--
try starting psql with the -E option -- this displays all queries used
internally to the screen, i.e.:
bash-2.04$ psql -E
* QUERY *
SELECT usesuper FROM pg_user WHERE usename = 'mfork'
*
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyri
Tom Lane wrote:
>
> Boulat Khakimov <[EMAIL PROTECTED]> writes:
> > Here is a nifty query I came up with
> > that provides a detailed information on any row of any table.
> > Something that is build into mySQL (DESC tablename fieldname)
> > but not into PG.
>
> Er, what's wrong with psql's "\d t
Boulat Khakimov <[EMAIL PROTECTED]> writes:
> Here is a nifty query I came up with
> that provides a detailed information on any row of any table.
> Something that is build into mySQL (DESC tablename fieldname)
> but not into PG.
Er, what's wrong with psql's "\d table" ?
Hi,
Here is a nifty query I came up with
that provides a detailed information on any row of any table.
Something that is build into mySQL (DESC tablename fieldname)
but not into PG.
SELECT a.attname AS Field,
c.typname as Type,
a.atttypmod-4 AS Size
FROM pg_attribute a,
pg
