[SQL] SQL Question

Hello, I hope this question is not too novice for this group. I have a table portfolio=# \d questions Table "questions" Attribute |Type | Modifier ---+-+---

Re: [SQL] on line numbers, drop table errors, and log files

Hi. Here are the options for pg_dump: -a dump out only the data, no schema -c clean (drop) schema prior to create -d dump data as INSERT, rather than COPY, commands -D dump data as INSERT commands with attribute names -hserver host name -i p

[SQL] PL/Tcl

Hi all, I hope I am asking this in the right list... I apologize if I am not. Is there a way to loop through a query in PL/Tcl, like the FOR .. IN in PL/PGSQL ? I need to write some functions that do DROP and DELETE and AFAIK those can't be handled from PL/PGSQL.

[SQL] copy with libpq?

I want to use copy ( file -> db ) with a command in C. How do i? Thanks.

[SQL] on line numbers, drop table errors, and log files

Hello- A few quick questions, I'm interested to know how people solve these issues. Thanks! (BTW: Pg 7.0.2) 1) Is there a way to find discover the line number of a script that causes an error? I mean, if I "\i script.sql" a 2000 line script, it is often difficult to track down that it was lin

Re: [SQL] New book on Postgres

On Wed, 07 Jun 2000, Ted Kennedy wrote: > We are evaluating a ten-page proposal for a new book on Postgres and are > looking for a few people to advise us on its viability. If interested, > please email me at [EMAIL PROTECTED] with a brief description of your > credentials and a statement that you