Re: [SQL] Matching the MYSQL "Describe " command

2005-04-24 Thread Tom Lane
Stephen Frost <[EMAIL PROTECTED]> writes: > You might want to take a look at the schema called 'information_schema' > and see if you can find what you want there. The only problem I have > with that, currently anyway, is that it seems to only show things the > current user owns as opposted to what

Re: [SQL] to_char(interval) ?

2005-04-24 Thread Bruno Wolff III
On Sun, Apr 24, 2005 at 13:08:04 -0700, Theodore Petrosky <[EMAIL PROTECTED]> wrote: > how do I get an interval '1 day 1 hour' to display as > '25 hours'. I am hunting in the docs (and googling) > and either I am blind or I need a special function? > > Is there an easy way? EXTRACT epoch from t

Re: [SQL] php wrapper

2005-04-24 Thread John DeSoi
On Apr 21, 2005, at 8:00 AM, Mauro Bertoli wrote: Hi, I need a PHP wrapper for PostgreSQL... I found 1000 small "+/- identicals" wrappers but incompleted There's an "ufficial" or an suggested PHP wrapper? Why not use the built-in PHP functions for PostgreSQL? If by wrapper you mean an abstraction

Re: [SQL] Matching the MYSQL "Describe " command

2005-04-24 Thread Andrew - Supernews
On 2005-04-24, Alan Chandler <[EMAIL PROTECTED]> wrote: > I am rather new to Postgres (running 7.4) but I am trying to port some PHP > code that has been built to run with mysql. > > I have got stuck trying to find the equivalent of the Mysql "DESCRIBE >;" SQL statement that lists the columns and

[SQL] to_char(interval) ?

2005-04-24 Thread Theodore Petrosky
how do I get an interval '1 day 1 hour' to display as '25 hours'. I am hunting in the docs (and googling) and either I am blind or I need a special function? Is there an easy way? Ted __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam

Re: [SQL] Matching the MYSQL "Describe " command

2005-04-24 Thread Stephen Frost
* Alan Chandler ([EMAIL PROTECTED]) wrote: > I am rather new to Postgres (running 7.4) but I am trying to port some PHP > code that has been built to run with mysql. > > I have got stuck trying to find the equivalent of the Mysql "DESCRIBE > ;" SQL statement that lists the columns and type ident

Re: [SQL] Matching the MYSQL "Describe " command

2005-04-24 Thread Alvaro Herrera
On Sun, Apr 24, 2005 at 07:02:16PM +0100, Alan Chandler wrote: > I am rather new to Postgres (running 7.4) but I am trying to port some PHP > code that has been built to run with mysql. > > I have got stuck trying to find the equivalent of the Mysql "DESCRIBE > ;" SQL statement that lists the co

[SQL] Matching the MYSQL "Describe " command

2005-04-24 Thread Alan Chandler
I am rather new to Postgres (running 7.4) but I am trying to port some PHP code that has been built to run with mysql. I have got stuck trying to find the equivalent of the Mysql "DESCRIBE ;" SQL statement that lists the columns and type identifiers of a table. I think I am going to do a SELEC

[SQL] unsubscribe

2005-04-24 Thread Alexander Vlasenko
unsubscribe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster