473,326 Members | 2,192 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

psql /copy to weirdness - data not showing up when selecting from table

Hello,

I am using psql on my client machine and attempting load a simple CSV file to table. My /copy command runs fine, but when I select from the table it isn't showing any of the rows that I just copied. The weird part is that when I /copy from the table to another file on my client machine I see the rows that I had imported.

Any ideas, advise?

Thanks!
May 5 '11 #1
0 2101

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: webhigh | last post by:
I¹m not sure if this a PHP question or an MySQL question but here it goes. I have a repeat region of a table called userid What I¹m trying to accomplish is being able to edit the record and...
0
by: steven | last post by:
In both mysql version 4.0.16 and 4.1.8 I'm running into deadlock behavior that I don't understand: can anyone explain why the following happens? Heres a basic table definition that exhibits the...
5
by: Peter CCH | last post by:
Let's say, I have Table1 and Table2, both with the exactly same structure and data in it, except that Table1.Field1 is empty in data but Table2.Field1 have data in it. How could I copy all the...
1
by: Parintas Themis STE Kardias | last post by:
Hi I have two tables the name of one table are fix, the name from the other it's selected from one combo box. How can make with a code under a command button, to Copy the data of the table wich...
1
by: rgdwar1 | last post by:
Hello, I have two issues I need help with: I have a Data Entry form called Frm_Entry (with a corresponding table) with the following fields: Date Assigned (Date) Date Processed (Date) Date...
1
by: nordy | last post by:
Hi, I have these tables with binary data stored in tinyblobs and blobs in MySql. In my application I sometimes need to copy them to another table. Not all the data, maybe just a column or two. So...
0
by: BigRedEO | last post by:
I am needing to SELECT all fields/records from a large table (96 columns, over 100 million records) into an outfile. I need to change any "NULL" to a blank. I can use "SELECT...
0
by: Zimectrin | last post by:
Found this code on this site. It seems to work except for one problem. Only the first five of 20 fields are copied. I have done my due diligence to find some reason for this behavior, but now am...
0
by: ciao | last post by:
Hi, I have a list of data stored in a multidimensional table (5 rows, 12 lolumns). I need to find the min value of each row, so i want to store the contents of each row to a "simple" table (so...
2
by: dave jones | last post by:
I am currently importing data from an SQL table into a local array in VB5. It goes along fine but then I get the following error: Run-time error 3163 The field is too small to accept the amount...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.