Re: [SQL] pg_dump more than one table in one command?

Looks like you are right, Scott. Thanks! I wasn't in Postgres land back then. On Mon, Oct 6, 2008 at 5:48 PM, Scott Marlowe <[EMAIL PROTECTED]>wrote: > On Mon, Oct 6, 2008 at 3:24 PM, Harold A. Giménez Ch. > <[EMAIL PROTECTED]> wrote: > > > > On Mon, Oct 6, 2008 at 5:02 PM, Emi Lu <[EMAIL PROTECT

Re: [SQL] pg_dump more than one table in one command?

On Mon, Oct 6, 2008 at 3:24 PM, Harold A. Giménez Ch. <[EMAIL PROTECTED]> wrote: > > On Mon, Oct 6, 2008 at 5:02 PM, Emi Lu <[EMAIL PROTECTED]> wrote: >> >> Good morning, >> >> Under postgreSQL 8.0, could someone tell me how to pg_dump more than one >> tables at the same time please? >> >> I tried

Re: [SQL] pg_dump more than one table in one command?

You must specify --table (or -t) once for each of the tables, ie: pg_dump -h machineName -U username --inserts --column-inserts --file=dump.sql --table=t1 --table=t2 . . --table=tN -d databaseName ; -t t1 -t t2 -t t3 On Mon, Oct 6, 2008 at 5:02 PM, Emi Lu <[EMAIL PROTECTED]> wrote: > Go

[SQL] pg_dump more than one table in one command?

Good morning, Under postgreSQL 8.0, could someone tell me how to pg_dump more than one tables at the same time please? I tried to do something like: pg_dump -h machineName -U username --inserts --column-inserts --file=dump.sql --table=t1 t2 ... ...tN -d databaseName ; Thanks a lot! -- Sen

Re: [SQL] many-to-many relationship

On Mon, Oct 06, 2008 at 09:25:09AM -0400, Dan McFadyen wrote: > Hello, > > Simplest way I can think of is create 3 relation tables, a person/image > table, location/image table and event/image table. > > Each is just made up for 2 foreign keys to the first ID and image ID, > using both as the PK

Re: [SQL] many-to-many relationship

Louis-David Mitterrand wrote: Hi, Say you have several objects (tables): person, location, event, etc. all of which can have several images attached. What is the best way to manage relations between a single 'image' table and these different objects? For now each 'image' row has pointers to id

[SQL] many-to-many relationship

Hi, Say you have several objects (tables): person, location, event, etc. all of which can have several images attached. What is the best way to manage relations between a single 'image' table and these different objects? For now each 'image' row has pointers to id_person, id_location, id_event,