Re: [GENERAL] Full Text Search 101?

2009-11-12 Thread Aurynn Shaw
n that is a bit easier > to understand? I know my database is far from complicated but I can't > seem to find a configuration that works well. When I try ranking my > results, most of the results end up with the same rank, so something > must be wrong? > > Can someone point

Re: [GENERAL] Dump all objects under a specific schema

2007-08-08 Thread Aurynn Shaw
Hi; Hello List, Is there a way that I can only dump all objects under a specific schema? I'd like to dump all tables, views' definition and data under a specific schema. pg_dump --help says that you're looking for the -n flag, so, pg_dump -n -f output.sql Hope that

Re: [GENERAL] Mac OS X

2007-07-12 Thread Aurynn Shaw
nally, I use the PG package available on http://www.entropy.ch/ software/macosx/postgresql/. It worked flawlessly, set up initdb, and configured PG to start at boot time. Thanks, Aurynn Shaw The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 ext 103 PostgreSQL Replication, Consult

Re: [GENERAL] collision in serial numbers after INSERT?

2007-06-01 Thread Aurynn Shaw
(sequence_value_you_selected, 'some data'); You can read more about how sequences work http://www.postgresql.org/docs/current/static/functions-sequence.html Hope that helps, Aurynn. On 6/1/07, Aurynn Shaw <[EMAIL PROTECTED] > wrote: > Hello all - > > I'm working o

Re: [GENERAL] On-line / off-line trace of SQL statements presented to the Postgres SQL engine

2007-05-30 Thread Aurynn Shaw
your JDBC connection before your application begins to query the database. http://www.postgresql.org/docs/8.2/static/runtime-config-logging.html Hope that helps. Aurynn Shaw The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 suppo