[pgadmin-support] exporting date values from access
Hi, maybe I'm loosing something obvious, but every time I try to export date values from Access tables the database migration wizard returns error rolling back. I'm mapping access date fields to postgre date fields but the wizard takes the complete date/time value trying to insert it in the corresponding postgre date field... see the log! I'm trying to migrate via pgadmin from access date values (time set to 00:00:00) , time values (date set to 1899-12-30) and timestamp (date with time) values to corresponding postgre fields, but how this can be done? (access has only one type of date/time value with different rappresentation) How can I migrate fields defaults too? How can I alter from pgadmin column properties (typically change data type) ? Thanks and regards Zoltan Pelva K-Soft [EMAIL PROTECTED] pgAdmin II_1292.Log Description: Binary data ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-support] I CAN´T SEE ANY TABLES WITH PGADMIN
Hi. i have a latest version of pgAdminII and postgres7.3.2, when connect to a database pgadmin show all databases but not show any more in the list only show for example database languages(0) schemas(1) not show tables, vistas, functions, nothing any idea thank yuo mario ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[pgadmin-support] unsubscribe
---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] RE: [pgadmin-support] I CAN´T SEE ANY TABLES WITH PGADMIN
> -Original Message- > From: Mario Alberto Soto Cordones [mailto:[EMAIL PROTECTED] > Sent: 23 March 2003 19:31 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] I CAN´T SEE ANY TABLES WITH PGADMIN > Importance: High > > > Hi. > > i have a latest version of pgAdminII and postgres7.3.2, when > connect to a database pgadmin show all databases but not show > any more in the list only show > > for example > >database >languages(0) >schemas(1) > > not show tables, vistas, functions, nothing > > any idea > > thank yuo Hi Mario, Try looking in a schema. Regards, Dave. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] exporting date values from access
Title: Message -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 23 March 2003 18:21To: [EMAIL PROTECTED]Subject: [pgadmin-support] exporting date values from access Hi, maybe I'm loosing something obvious, but every time I try to export date values from Access tables the database migration wizard returns error rolling back. I'm mapping access date fields to postgre date fields but the wizard takes the complete date/time value trying to insert it in the corresponding postgre date field... see the log! I'm trying to migrate via pgadmin from access date values (time set to 00:00:00) , time values (date set to 1899-12-30) and timestamp (date with time) values to corresponding postgre fields, but how this can be done? (access has only one type of date/time value with different rappresentation) Hi Zoltan, Please try the snapshot from the binaries folder at http://cvs.pgadmin.org/. Installation nstructions are in the README. How can I migrate fields defaults too? This is currently not supported, but can be done manually in pgAdmin after migration. How can I alter from pgadmin column properties (typically change data type) ? If you select the Properties page (right-click, Properties) of the column you want to change, you can edit some details on the Properties form. You cannot change the column data type however as PostgreSQL doesn't support this. Regards, Dave.
