Re: [GENERAL] Schema
At 12:51 19/12/00 -0500, gerardo tagliani wrote: Somebody knows how to get a sql "schema" of a Postgresql database?? Thanks!! pg_dump -s databasename -- thorNET - Internet Consultancy, Services Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
Re: [GENERAL] Schema
At 10:04 19/12/00 -0800, Adam Haberlach wrote: On Tue, Dec 19, 2000 at 12:51:26PM -0500, gerardo tagliani wrote: Somebody knows how to get a sql "schema" of a Postgresql database?? pg_dump -s -d dbname No. -d does something to the INSERT strings -- thorNET - Internet Consultancy, Services Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
Re: [GENERAL] Sql query with partial matching
At 14:58 07/12/00 -0500, Travis Bauer wrote: How would I write an sql statement which would select all the records from a table where some string field contains some substring? Example: find all the records where f1 contains the world "cool." select * from table where f1 ~ 'cool'; or case insensitive select * from table where f1 ~* 'cool'; Steve -- thorNET - Internet Consultancy, Services Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
Re: [GENERAL] How do I install pl/perl
At 10:02 30/11/00 +0100, Marcin Bajer wrote: Steve Heaven wrote: At 13:06 29/11/00 -0500, Robert B. Easter wrote: When you compiled PostgreSQL, you have to give ./configure --with-perl so it will make the .so file its looking for. See ./configure --help next time. We installed from RPM not source. Do we have to do a re-install from source to get this working ? Steve I think not. There is a RPM called postgresql-perl-*.rpm - installing it should be enough. We already have that package installed. It provides the Perl Pg module to interface to a Postgres backend, not to write stored functions. Steve -- thorNET - Internet Consultancy, Services Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
Re: [GENERAL] How do I install pl/perl
At 13:06 29/11/00 -0500, Robert B. Easter wrote: When you compiled PostgreSQL, you have to give ./configure --with-perl so it will make the .so file its looking for. See ./configure --help next time. We installed from RPM not source. Do we have to do a re-install from source to get this working ? Steve -- thorNET - Internet Consultancy, Services Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
Re: [GENERAL] Error with tcp/ip networking
At 10:15 31/08/00 -0400, Tom Lane wrote: Actually I think netstat only shows open connections, not processes listening for connections. Does anyone know a (reasonably portable) way of seeing which port numbers are being accept()ed on? netstat -a | grep LISTEN works on most UNIX flavours
Re: [GENERAL] Upper and Lower case sensitivities
At 09:20 30/08/00 -0300, Campbell, Scott wrote: Hey, Is there a function within postgres that lets you search for both upper and lower case at the same time? I know of the upper() and lower() functions but if a word has both upper and lower case in it it won't be returned by a query. Or am I limited to forcing my data to have one case only? select * from foo while column_name ~* 'matchstring';
[GENERAL] DBD-Pg vs Pg Perl interface
We currently use the Pg Perl module to interface our CGI scripts to Postgres. What would be the advantages/disadvantages to changing to the more generic DBI/DBD-Pg style interface? Thanks Steve -- thorNET - Internet Consultancy, Services Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
Re: [GENERAL] order by rand()
At 23:46 18/07/00 +0200, Peter Eisentraut wrote: Mike Sears writes: I'm wondering if postgress is able to do order by rand() or if it is done by some other means through php easily The function is called random(), but yes, it works. Is this a 7.x only feature ? With 6.5.2 I get select * from topten where room='SM' order by random(); ERROR: No such function 'random' with the specified attributes -- thorNET - Internet Consultancy, Services Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk
Re: [GENERAL] Re: importing into postgres from access
At 16:31 11/07/00 +0930, Stephen Davies wrote: You can in fact access an Access database from Linux. Just install the Universal ODBC stuff from OpenLink URL please, neither openlink.com nor openlink.org seem to be the right places. Thanks Steve -- thorNET - Internet Consultancy, Services Training Phone: 01454 854413 Fax: 01454 854412 http://www.thornet.co.uk