Re: [GENERAL] pg_get_serial_sequence and table inheritence

[Rafa Couto]

2005/5/31, Timothy Perrigo [EMAIL PROTECTED]:

 I'd like to be able to call pg_get_serial_sequence passing derived
 for the table and id for the sequence column (to get, in this case
 base_id_seq).  If nothing like this currently exists, any
 suggestions on how I could write a plpgsql function to get this
 behavior?

  You have one sequence for every serial field in sequences (from psql: \ds).
  

-- 
Rafa Couto (caligari)
mailto:[EMAIL PROTECTED]

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings

RE: [GENERAL] Postgres 7.0.2 and ODBC

[Rafa Couto]

 Can I use ODBC driver for windows version 6.5 to connect to postgres
7.0.2?

Yes, you must (there is no ODBC driver version  6.5 for win, I think)

[GENERAL] RE: Importing into Postgres from a csv file

[Rafa Couto]

- Mensaje original -
De: "Jake" [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviado: miércoles, 23 de agosto de 2000 21:56
Asunto: [GENERAL] Importing into Postgres from a csv file


 Does any one know if this is possible, and if so how?

Use copy command:

COPY table FROM 'data.csv'
USING DELIMITERS ','
WITH NULL AS 'null string'
  ;

RV: [GENERAL] Tables Question

[Rafa Couto]

 How can I retrieve the "names" of all the tables in my database ?

In Postgres 7:

From psql: \dt
or \d for all objects

From SQL:
select * from pg_tables where tablename not like 'pg_%';