One sql statement can solve this:
sql> isnert into table_b (id, name, summary) select id, name, desc from
table_a;
Banghe
Mike Darretta wrote:
Does anyone have a suggestion on the best way to migrate data between
two slightly different tables? For example:
Table A
id : integer
n
=
tmp.route_id
LIMIT 10 ;
This is without ( ).
Banghe
Tyler Ward wrote:
I'm using postgres 7.3.x (the default installed on Fedora Core 1) and
I'm running into a serious
bug in the insert performance.
When I try a query like this...
INSERT INTO table_a (session, sent, data_row, di
Hi,
Your query should be written in much simple way:
SELECT Monatsbeitrag.lfdid, Daten.Kundennummer FROM Daten, Monatsbeitrag
WHERE
(Daten.Vetrag widerufen = 2) AND
Daten.ewmanfrdat IS NOTNULL AND
(Monatsbeitrag.ID = Daten.Kundennummer ) AND
((Monatsbeitrag.Monat + 14 ) = '2003-10-27 00
You may use type real? -- Banghe
Meibell Contreras wrote:
hello; Anyone
knows if postgres has a bigger data type than money...when
you use this; (not with dollar definition); the money data type is not
enough... graciasMeibell
You just need to cut this column. e.g. use perl you can use:
new_column = substr(old_column, 0, 19)
Or you can use the function to convert to what you want when you select this
column from the table. Check functions
--
Banghe
Jack Zhu wrote:
> Hi, all:
>
> PostgreSQL 7 Beta 5 o
Here is my suggestion:
Just for this test, change plpgsql.so access code as 777,
after you test, change it back as 640.
Macht das schoen?
Grusse,
--Bangh
Reiner Dassing wrote:
> Hello!
> After installation the PostgreSQL Version 6.5.2 on Digital Unix V4.0F
> I did the regression tests.
>
> T
Upon his requirement, you also need to grant this administrator as a superuser of
postgres
when you run shell command createuser.
--Banghe
"Doran L. Barton" wrote:
> Not long ago, Mike Field proclaimed...
> > I'm getting a bit confused by the manual on this one, so
> >RULE has special meaning. Other previliges you can grant are:
> >select, delete, update
> >
> >--Banghe
>
> Ahhh! Just what is the special meaning of RULE?
It means you grant a user privilege that he can create RULE on the table.
( you can get more info ho
make sure the postmaster on postgres server is running.
You can check if it is listening:
netstat -an | grep 5432
--Banghe
Andrew Higgs wrote:
> Hi all,
>
> I am writing a program in Delphi which connects to my linux postgres box
> (6.5.1). This was working just fine until th
under psql you can get help for SQL statement grant.
grant rule on table to someone
menas you grant someone on the table previlige: RULE.
RULE has special meaning. Other previliges you can grant are:
select, delete, update
--Banghe
hal Lynch wrote:
> In the following grant statement w
Hi ,
There is no problem to do so.
Check this file:
pg_hba.conf
You can set host-base access control.
--Banghe
[EMAIL PROTECTED] wrote:
> Hello,
>
> My postgresql base is on machine A. Me I'm on machine B.
> I would like
> to connect to my postgresql system from machine
Hello,
Q: how to add entry in pg_hba.conf?
I manually added an entry in pg_hba.conf as:
host template1 postgres_IP 255.255.255.0 banghe banghe
But as I run the code and got msg:
the file pg_hba.conf is crashed.
I wonder if I can manually edit this file.
(to locally connect postmaster seems
. If it is yes, then maybe the problem is postgres
user setting.
-- Banghe
Matthew wrote:
> I'm running postgresql 6.5.1 on Redhat 6.0. I am trying to move a
> database to a new box running 6.5.3. So I tried a 'pg_dump db_name >
> db_name.out' so that I could rest
13 matches
Mail list logo
