Re: [SQL] using copy from in function

2008/3/4, Yura Gal <[EMAIL PROTECTED]>: > I'm trying to automate import data using CORY FROM. For this purpose I > wrote plpgsql function. As my postgres works on windows vista I need > to use E'' syntax for path-to-file. This syntax works fine in SQL > queries like: > COPY table FROM E'path_to

[SQL] using copy from in function

I'm trying to automate import data using CORY FROM. For this purpose I wrote plpgsql function. As my postgres works on windows vista I need to use E'' syntax for path-to-file. This syntax works fine in SQL queries like: COPY table FROM E'path_to_file_with_double_backslashes'; Following query works

Re: [SQL] Documenting a DB schema

Shahaf Abileah wrote: I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recomme

Re: [SQL] Documenting a DB schema

Hi, I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommendations? I am usi

[SQL] Documenting a DB schema

I'm looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommendations? It would be g

Re: [SQL] compiling plpython compilation error (solved)

Tom Lane wrote: Gerardo Herzig <[EMAIL PROTECTED]> writes: Hi all. Im having a hard time trying to compile the plpython package. This is the error make gives me: /usr/lib/python2.5/config/libpython2.5.a(abstract.o): relocation R_X86_64_32 against `a local symbol' can not be used w

Re: [SQL] php to pgsql question

On Tuesday 4. March 2008, li ethan wrote: >HI guys! >I've been encounting a problem when I configured PHP to support >Postgres.I think may be someone in here can solve my problem. >Postgres version is 8.1.4,and the install path is > /usr/local/pgsql, PHP is 4.4.2. >I use this parameter

[SQL] php to pgsql question

HI guys! I've been encounting a problem when I configured PHP to support Postgres.I think may be someone in here can solve my problem. Postgres version is 8.1.4,and the install path is /usr/local/pgsql, PHP is 4.4.2. I use this parameter to configure PHP--with-pgsql=/usr/local/pgsql