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

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

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

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

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

[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

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 *

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