Hi Sachin,
I am sorry but I am not that familiar with Linux. So you have excuse me.
I can't figure out how to do this. I looked for it in the package manager
and googled it but no luck.
What commands should I run to install and run it?
Thanks in advance / Jennifer
i am using a friends account btw...
inking that I should change
:
pg_dump -U postgres prodDB > /var/a/db/$(date "+%Y-%m-%d_%H:%M")-prodDB.dump
Thank you in advance / Moe
Thank you both, that did the trick.
Sincerely / Moe
On Tue, Jan 26, 2010 at 7:14 PM, Tom Lane wrote:
> Moe writes:
> > I have a simple script file db :
> > #!/bin/bash
> > pg_dump -U postgres prodDB > /var/a/db/$(date
> "+%Y-%m-%d_%H:%M")-prodDB.dump
Is it possible to set postgres in case insensitive mode ?
If so, how?
Thanks / Moe
On Sat, Jan 30, 2010 at 4:44 AM, Scott Marlowe wrote:
> On Fri, Jan 29, 2010 at 7:40 PM, Scott Marlowe
> wrote:
> > On Fri, Jan 29, 2010 at 2:52 PM, Moe
> wrote:
> >> Is it possible to set postgres in case insensitive mode ?
> >>
> >> If so, how?
>
y
existing tsearch2 index.
Words that are frequent in the index could be ranked higher as a search tip.
Is there a way to query the actual existing index?
How else could one approach this? There are many sites that uses this, so
perhaps there is an easier way I haven't thought of yet.
Thank you / Moe
Bump
On Fri, Feb 5, 2010 at 5:48 PM, Moe wrote:
> I am trying to figure out how I can introduce full text search "tips"...
> tips meaning, like if you start typing Mer ..
> then a box with a couple of words underneath comes up, with *Mercedes,
> Mercury *and so on :P
>
On Thu, Feb 11, 2010 at 6:56 PM, Richard Huxton wrote:
> On 05/02/10 15:48, Moe wrote:
>
>> I am trying to figure out how I can introduce full text search "tips"...
>> tips meaning, like if you start typing Mer ..
>> then a box with a couple of words u
Hi,
How can I add automatic backup easily?
Is it possible with pgadmin ?
Also, I would like to know whether those options (Blobs(checked), OIDS,
Insert Commands, Disable Quoting is for) .. as it is now, it works great
without them.
Thanks in advance / Moe
Hi all
We're trying to get our 64 bt windows application to use postgresql, which
means I have to #include stuff from psql and link to 64 bit versions of the
libs. Which do not seem to exist.
Spesifically I need to get Qt compiled with psql (and eventually postGIS).
Can anyone give me an update
? :)
Anders
On Mon, Nov 9, 2009 at 1:32 PM, Sam Mason wrote:
> On Mon, Nov 09, 2009 at 09:47:48AM +0100, Anders Moe wrote:
> > We're trying to get our 64 bt windows application to use postgresql,
> which
> > means I have to #include stuff from psql and link to 64 bit ve
Access privileges
-
--+--+---+-
~ sma_apps | ordr_dat | table | {sma_admin=arwdRxt/sma_admin,"group
sma_user_group=arwd/sma_admin"}
~ When logged in as sma_user, it is denied access to the schema:
ERROR: permission denied for schema sma_apps
What am I missing? How do I provide access to a sc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 15 Dec 2003 09:13:49 +, Tony wrote:
>excel it's previous incantation.
>
The spelling is "its", not "it's".
"Its" is a possessive pronoun. "It's" is a contraction for &qu
So with 2 itanics you get a slight improvement. With 4 xeons you get
about 1.7x improvement over your current setup.
--
jimoe at sohnen-moe dot com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.post
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 14 Aug 2003 18:48:43 -0500, Andrew L. Gould wrote:
>>
>> What you're looking for is COPY:
>>
>> http://www.postgresql.org/docs/7.3/static/sql-copy.html
>>
Thanks! That was it.
- --
jimoe at sohnen-m
t_per_box| numeric(6,2) | default 1
is_archived | smallint | default 0
Indexes: vprd_dat_pkey primary key btree (prod_no)
A typical line of input data (wrapped, no doubt):
'A111' 'Is Your Net Working? Audio'34.95 (NULL) (NULL)
--
jimoe at sohnen-moe dot com
pgp/gpg public key: http://www.keyserver.net/en/
-BEGIN PGP SIGNATURE-
Version: PGPfreeware 5.0 OS/2 for non-commercial use
Comment: PGP 5.0 for OS/2
Charset: cp850
wj8DBQE/bzDcsxxMki0foKoRAsgqAKCwzfP1d4qo1bN3FmVm1dMOS1/5IgCeNLhu
0I6koUHZimntHk2F05A0gY4=
=W
n, IDE is the way to go.
SCSI has a long history of providing sustained throughput for server systems.
IDE has a short history of providing very cheap storage for desktops.
- --
jimoe at sohnen-moe dot com
pgp/gpg public key: http://www.keyserver.net/en/
-BEGIN PGP SIGNATURE-
Version: PG
out a server would have it backed up with a UPS and
appropriate software to shut the system down during an extended power outage. This
just
leaves people tripping over the power cords or maliciously pulling the plugs.
- --
jimoe at sohnen-moe dot com
pgp/gpg public key: http://www.keyserver.
't_st%';
or
select * from test where name like 'tést%' or name like 'test%' ...
--
jimoe at sohnen-moe dot com
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Christian Rank wrote:
create table a (n integer);
create table b (n integer);
alter table a add primary key (n);
alter table b add foreign key (n) references a(n);
Have you considered using "on delete cascade" in table b?
--
jimoe at sohnen-m
22 matches
Mail list logo
