[SQL] unsubscribe

unsubscribe ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[SQL] Matching the MYSQL Describe table-name command

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 tablename; SQL statement that lists the columns and type identifiers of a table. I think I am going to do

Re: [SQL] Matching the MYSQL Describe table-name command

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 tablename; SQL statement that lists the

Re: [SQL] Matching the MYSQL Describe table-name command

* 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 tablename; SQL statement that lists the columns and type

[SQL] to_char(interval) ?

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 table-name command

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 tablename; SQL statement that lists the columns

Re: [SQL] php wrapper

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 to

Re: [SQL] to_char(interval) ?

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 the

Re: [SQL] Matching the MYSQL Describe table-name command

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 the