Re: [SQL] Question about a CIDR based query

Hi Josh, Ok, first the explain analyze June_03=# explain analyze select * from tmp where route >>='62.1.1.0/24'; QUERY PLAN --- Seq Scan on

Re: [SQL] best method to copy data across databases

[EMAIL PROTECTED] (Tony Reina) writes: > If the 2 tables have different arrangements, then I'm not sure if > there is a quick way. The safest way is probably to do a pg_dump > --attribute-inserts. In recent versions (definitely 7.4, don't remember about 7.3), pg_dump will include a column list in

Re: [SQL] best method to copy data across databases

[EMAIL PROTECTED] (ctrl) wrote in message news:<[EMAIL PROTECTED]>... > I need to copy data that I have on a table in one Postgres database > into another table, on a different database. The destination table is > not identical with the source table so I need to do some mapping > between the 2 tabl

Re: [SQL] quoting

I could not found an other quoting. This quoting us annoying me also. I would be nice to have an additional simpler quoting in one of the next versions. - From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 30. Juni 2004 07:12 To: [EMAIL PROTECTE