[ADMIN] field order

2001-11-30 Thread Dado Feigenblatt
Do field order affect performance? Does PostgreSQL reorder the fields in the tables? Does it try to move variable lenght fields to the end of the table, and indexed ones to the beginning? Does it matter at all? Thanks. -- Dado Feigenblatt Wild Brain, Inc. Tec

[ADMIN] psql option for writing schema

2001-11-30 Thread Tony Reina
I seem to remember a psql option that dumped out the table schema. I can't seem to find it in the man for psql. Could someone point out the option to me? Thanks. -Tony ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.

[ADMIN] rename database

2001-11-30 Thread Leong, Fushan
Hi : I am working on the procedure to restore a database from dump file ( pg_dump ). I am thinking to create a new database, then restore the dump file, drop the old database and rename the old database to new database. Do postgres has command to rename the database? ---

Re: [ADMIN] Visio

2001-11-30 Thread Mikhail Terekhov
It works fine with the latest Postgrs ODBC driver here. Regards, Mikhail Jodi Kanter wrote: > This is a multi-part message in MIME format. > > --=_NextPart_000_000D_01C178EA.1F0F47A0 > Content-Type: text/plain; charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > I need

Re: [ADMIN] locale question

2001-11-30 Thread Tom Lane
Oliver Vecernik <[EMAIL PROTECTED]> writes: > ERROR: copy: line 1, Bad numeric input format '1018,11' > It seems the price with , is not recognized by psql, although LANG is set. IIRC, the only numerical datatype we have that allows locale-specific formatting is MONEY, which is deprecated for l

Re: [ADMIN] table test

2001-11-30 Thread Brian McCane
On Fri, 30 Nov 2001, Nick Fankhauser wrote: Actually, I suspect that accessing data in Table 1 might be faster. If they are gonna create the table like such: create table foo1 (f1 varchar(100), f2 varchar(100), f3 varchar(100)) ; Because of the variable length of each field, the record would h

[ADMIN] locale question

2001-11-30 Thread Oliver Vecernik
Hi, I've got SuSE 7.3 with PostgreSQL 7.1.3 server an a system where LANG=de_DE@euro. I tried to import some data with: \copy im from '/usr/share/data/pricelist.csv' using delimiters '|' and got following message: \. ERROR: copy: line 1, Bad numeric input format '1018,11' PQendcopy: resettin

Re: [ADMIN] table test

2001-11-30 Thread Nick Fankhauser
Manuel- I'm still a bit confused, but will try to answer (maybe someone else can jump in with a better interpretation). Generally, the structure of the information you are storing should determine the structure of the tables, so if there are three distinct fields in the data, table one would be

[ADMIN] wiew's & cache

2001-11-30 Thread Manuel Trujillo
Hi. Can Postgresql make a cache of different view's? Is for a dynamic website. Thank you. -- Manuel Trujillo [EMAIL PROTECTED] Technical Engineer http://www.motograndprix.com Dorna Sports S.L. +34 93 4702864 ---(end of broadcast)-

Re: [ADMIN] table test

2001-11-30 Thread Manuel Trujillo
On Thu, Nov 29, 2001 at 12:12:04PM -0500, Nick Fankhauser wrote: > I did not understand the question. Can you restate your purpose or tell us > more about what you are trying to achieve? > > (No entendía la pregunta. ¿Puede usted exponer su propósito en forma > modificada o decirnos más sobre lo