I believe in postgres, doing
\t /path/to/file (hit enter)
Will then redirect the pipit of the following commands to that file.
It'd save you from having to Copy/paste data
Sent from my iPod
On Jun 18, 2010, at 4:55 PM, Ricko <[email protected]> wrote:
Hi Mike,
Virtual beer for you, worked like a charm!
Cheers
On Jun 18, 10:58 am, m1chael <[email protected]> wrote:
Hi!
Something like this would work in PostgreSQL, i'm not sure about
MySQL
though:
select first_name,last_name,email from contact_contact where id in
(select
contact_id from shop_order);
Hope it works out for you! :)
Maybe someone else can add more to this,
~Mike
On Fri, Jun 18, 2010 at 1:41 PM, Ricko <[email protected]> wrote:
Hi all,
I have a client who wishes to get a list of all the customers who
made
purchases on his Satchmo site. Can anyone assist in the correct SQL
statement? The admin gets close to doing that without needing a db
query, but it doesn't look like you can output the table data
as .csv
or anything useful.
Cheers
--
You received this message because you are subscribed to the Google
Groups
"Satchmo users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected]<satchmo-users
%[email protected]>
.
For more options, visit this group at
http://groups.google.com/group/satchmo-users?hl=en.
--
You received this message because you are subscribed to the Google
Groups "Satchmo users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected]
.
For more options, visit this group at http://groups.google.com/group/satchmo-users?hl=en
.
--
You received this message because you are subscribed to the Google Groups "Satchmo
users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/satchmo-users?hl=en.
