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 > No. -d does something to the INSERT strings -- thorNET - Internet Consultancy, Services

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] 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 i

[GENERAL] Regular expression question

Does the regular expression parser have anything equivalent to Perl's \w word boundary metacharacter? I want to select tuples where a text field contains a certail whole word. Using fieldname ~* 'searchword' wont work because it picks up the searchword emdedded in other words. Using ~*' searchwor

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

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 wor

Re: [GENERAL] warning - virus on the loose.

At 11:53 28/09/00 +1000, Christopher Smith wrote: > > >All, > >I don't normally do this but someone has just sent a virus to the list - Virus: >VBS_KAKWORM.A. >Pls check your systems for this virus (don't know the exact name of the file, >but the virus is above). >If its fake, sorry for any inconv

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

[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 htt

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 sel

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, Service