In
DATA1 you run SQL Query:
copy A
to 'PATH\tempA.txt'
Then
in DATA2 you run SQL Query:
copy A
from 'PATH\tempA.txt'
good
luck !
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On
Behalf Of Shavonne Marietta WijesingheSent: vendredi 14 octobre
2005
Tyler Kellen <[EMAIL PROTECTED]> writes:
> I have a question about a full outer join returning duplicate rows.
Why do you think they are duplicate? The GROUP BY includes many columns
that you can't see directly in the output ...
Also, you did not show us the actual input data (where's the rows w
On Fri, Oct 14, 2005 at 01:08:43PM -0500, Judith Altamirano Figueroa wrote:
> Hello I have a query that ran in 7.0.2, but in 8.0.1 does not, the query
> is the next:
It'd help if we could see the table schema and the error message.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information c
Hello I have a query that ran in 7.0.2, but in 8.0.1 does not, the query
is the next:
select n.factura,
n.venta_neta,
c.nombre_cli || ' ' || c.apellido_pat_cli || ' ' || coalesce
(c.apellido_mat_cli,''),
date(n.fecha_hora_factura),
The first query under 'BAD RESULT:' doesn't have anything to do with my question
Please disregard it!
mg=# select * from trans_item where id=20116;
id | trans_id | parent | qty | item_sku | item_price | item_tax
---+--++-+--++--
20116 |
I have a question about a full outer join returning duplicate rows.
I have one table that stores a record for each transaction with totals:
CREATE TABLE trans
(
id serial PRIMARY KEY,
stamp timestamp DEFAULT now(),
trans_type_id int NOT NULL REFERENCES trans_type(id
Yes, that worked. Thank you very much!
-- George
On Fri, 14 Oct 2005 12:04:13 -0400
Tom Lane <[EMAIL PROTECTED]> threw this fish to the penguins:
> george young writes:
> > How can I fix this?
>
> Re-create the owning user (which you evidently dropped), assigning it
> sysid 101.
>
> PG 8.1 w
george young writes:
> How can I fix this?
Re-create the owning user (which you evidently dropped), assigning it
sysid 101.
PG 8.1 will make it impossible to drop users who still own objects or
have permissions ... although that will bring its own set of gotchas ...
rega
[PostgreSQL 7.4RC2, x86 linux]
Several tables are giving the errors like:
pg_dump: WARNING: owner of data type "areas" appears to be invalid
from pg_dump.
This is my production database, (50 users, 18 hours/day, 21MB compressed dump).
The output of "pg_dump -t areas" starts with:
REVOKE ALL ON
Thanks Russ, but well...
It doesn't help me a lot. Our needs seem to allow that we use an id as
primary key and foreign key at the same time.
What i fear more is that it be against a good database design practice,
because leading to potential problems.
I give a clearer example :
CREATE TABLE act
I dont consider this to be a design problem... In fact... I do the inherited
table thing pretty routinely... It (table inheritance) works very well if
you need to implement a Sarbanes-Oxley audit trail or a "virtual" rollback
system without the overhead of managing transactions.
Consider the re
David Pradier wrote:
Most of the inheritance i've seen done in databases retain the parent primary
as a foreign key and a primary key. That being said, only you and your team can
decide if more than one object will extend a base class. If you were doing
something more like this
person -> sweep
INSERT INTO MYSCHEMA2.TABLENAME
SELECT * FROM MYSCHEMA1.TABLENAME WHERE < CONDITION >Shavonne Marietta Wijesinghe <[EMAIL PROTECTED]> wrote:
Hello
How can i copy a table from one schema to another..
Example..
* I have a database "mydatabase"
* then i have 2 schemas "myschema1" and "
Shavonne Marietta Wijesinghe <[EMAIL PROTECTED]> schrieb:
> I have 2 schemas "operativo" and "autore" and they both have a table "PECDT00"
>
> i want to create a function with the following sql command (using the
> programme
> pgadmin 3) in pgadmin 3 there is a small wizard to fill when u creat
I have 2 schemas "operativo" and "autore" and they both have a table "PECDT00"
i want to create a function with the following sql
command (using the programme pgadmin 3) in pgadmin 3 there is a small wizard to
fill when u create a function and u have to add the return type..
this is the
> Most of the inheritance i've seen done in databases retain the parent primary
> as a foreign key and a primary key. That being said, only you and your team
> can decide if more than one object will extend a base class. If you were
> doing something more like this
> person -> sweepstakes entry
Hi all,
I'm working with postgres
8.0.1 in a VB 6.0 application using pgOleDb 1.0.0.19. I'm
facing problems when using some features of Recordset object like:
AbsolutePage, RecordCount, PageSize, PageCount.
Are these properties
implemented??? Do I need make anything to enable then???
- Original Message -
i've got
a strange design question to ask you.It's something I couldn't answer to
while feeling confusely it was anabsolutely BAD thing to do.For
our application, we have developed our own framework which sits ontop of
PostgreSQL. It uses object progr
Sheesh...
I work with 2 MIT guys, and man, you guys will never admit you're wrong.
Must be something in the water down there ;)
Hey man, you know what, to each his own
(but Apostol is one of my favorites, so maybe have that in common? :)
You apparently like this shortcut, so be it.
I'll say th
am 14.10.2005, um 10:44:13 +0200 mailte Shavonne Marietta Wijesinghe folgendes:
> Hello
>
> How can i copy a table from one schema to another..
create table as select * from table
>
> Example..
Yeah!
test=# create schema foo;
CREATE SCHEMA
test=# create schema bar;
CREATE SCHEMA
test=# creat
Hi everybody,
i've got a strange design question to ask you.
It's something I couldn't answer to while feeling confusely it was an
absolutely BAD thing to do.
For our application, we have developed our own framework which sits on
top of PostgreSQL. It uses object programming and implements herita
Hello
How can i copy a table from one schema to
another..
Example..
* I have a database "mydatabase"
* then i have 2 schemas "myschema1" and
"myschema2"
* in "myschema1" i have inserted a new line and i
want to copy that to "myschema2" so they both will be same..
How can i do it with
am 14.10.2005, um 8:54:39 +0200 mailte Shavonne Marietta Wijesinghe folgendes:
> Hello
>
> I have 2 postgreSQL databases called "DATA1" and "DATA2" with several tables
> inside them (table A, B, C).
>
> I modify the details in table "A" in database "DATA1"
>
> How can I copy table "A" from
"Anthony Molinaro" <[EMAIL PROTECTED]> writes:
> More awkward? What *you're* suggesting is more awkward. You realize that
> right? How can syntax that is understood and accepted for years be more
> awkward?
Well gosh, I would say that that's something only a newbie could say about
SQL of all thi
24 matches
Mail list logo
